How to Check What is Getting / Being Audited in Oracle Database?

advertisements

_____________________________________________________________________________________________________________________

Below mentioned 3 data dictionary views can be used to fetch the details of the auditing.

dba_obj_audit_opts: Data dictionary view will give the details of auditing options on all objects. user_obj_audit_opts view will provide the details of the auditing enabled on the objects on the particular user session connected

dba_priv_audit_opts: Data dictionary view describes the current system privileges being audited across the database and by the user. The column username can be used to find the details user wise. The column value will be NULL for system-wide auditing

Example:

SQL> select * from DBA_PRIV_AUDIT_OPTS

SQL> /

USER_NAME PROXY_NAME PRIVILEGE SUCCESS FAILURE

---------- ---------- ------------------------------ ---------- ----------

CREATE EXTERNAL JOB BY ACCESS BY ACCESS

CREATE ANY JOB BY ACCESS BY ACCESS

GRANT ANY OBJECT PRIVILEGE BY ACCESS BY ACCESS

EXEMPT ACCESS POLICY BY ACCESS BY ACCESS

dba_stmt_audit_opts: Data dictionary view describes the current system auditing options across the database and by the user. The column username can be used to find the details user wise. The column value will be NULL for system-wide auditing

Example

SQL> select * from dba_stmt_audit_opts;

USER_NAME PROXY_NAME AUDIT_OPTION SUCCESS FAILURE

---------- ---------- ---------------------------------------- ---------- ----------

PROFILE BY ACCESS BY ACCESS

ROLE BY ACCESS BY ACCESS

DATABASE LINK BY ACCESS BY ACCESS

PUBLIC SYNONYM BY ACCESS BY ACCESS

_____________________________________________________________________________________________________________________

Archive