How to audit a particular table data

[hari5]

Hi,
I know that we can audit the users who are all accessing the reports and the login information also.
We would like to audit who are all accessing the customer related information from the customer table .
Could you please let me know how to findout the information.
Thanks in advance

[twlarsen]

Do you know what reports hit the customer table?

Or are you needing to know what customers are being accessed?  You can take a look at the native SQL sent and see.

[hari5]

hi,
Yes. We need to know what customers are being accessed.Most of the users have got access to customer table but we are not sure who are trying to create reports on customer table and accessing reports. we want to track the users who access the customer table data.

I am not sure about the native SQL. Can you please share your idea's

[twlarsen]

The native SQL is the usually the SQL that is sent to the DB.  You can find it in the NATIVEQUERY table in the audit database.

Do you have data security implemented?  This would make more sense that you can say only certain users can access certain customers rather then going through the SQL and seeing the actual data they accessed.

Hopefully someone else has a better answer...because you're going to have a lot of work if you are looking up individual queries to see what data they saw.