I'm using Oracle 11g R2 on RHEL5.
How can I find what is being audited? I want to know what actions (like create, insert, delete, update etc.) are being audited or logged for a user, say
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
This topic is documented in the Oracle Security Guide at the section Finding Information About Audited Activities.
In your case you should find useful the catalog view
DBA_OBJ_AUDIT_OPTS which displays the objects on which auditing options have been enabled.
Here is described the view structure.