How to track user access

MR13
Tera Contributor

Hi All,

 

I wanted to report on usage of table. So I am looking for a way where I can check the users accessed a table. How can I check this? I am not finding a table where it has usage data similar to applications in the u_app_usage table.

2 REPLIES 2

Raj_Esh
Kilo Sage
Kilo Sage

Hi MR,

 

u_app_usage seems custom table within your instance. Table name starts with "u" will be custom. 

For the auditing purpose, you can check the table sys_audit table, here it shows the auditing of operations performed on the table from a user.

 

Hope it helps.

 

Thanks,

Raj

--Raj

MR13
Tera Contributor

Hi Ash, 

 

I am aware of u_app_usage table but my question is how would I set up for specific table. The table gives overall view on the Application and all tables under that. 

 

I need access for a specific table.