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 scott.

  • 1
    Aren't they all listed in the manual?
    – mustaccio
    Nov 1 '13 at 13:58

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.

  • -1 in my opinion oracle auditing views are rather confusing. so there should be more than some links to a manual. A concrete example of how one could find what is logged for user SCOTT would be useful, and will it be loged if the user SCOTT changes data in the tanble EMP?
    – miracle173
    May 3 '14 at 11:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.