If AUDIT_TRAIL is not set to NONE then using the following SQL one can find the statements that have auditing turned on. SQL> SELECT * FROM dba_stmt_audit_opts union SELECT * FROM dba_priv_audit_opts; USER_NAME PROXY_NAME —————————— —————————— AUDIT_OPTION SUCCESS FAILURE —————————————- ———- ———- ALTER ANY PROCEDURE BY ACCESS BY ACCESS ALTER ANY TABLE BY ACCESS BY ACCESS ALTER DATABASE BY ACCESS BY ACCESS .. Advertisements Continue reading How to check if auditing is turned on and privilege auditing is turned on?
By setting the parameter “AUDIT_TRAIL” to “DB” or “OS”, one can enable auditing in the database. To change the value of the parameter you would need to bounce the database for the new value to take into effect. The default value of the parameter is “NONE” in which database auditing is disabled. Even if “AUDIT_TRAIL” is enabled/disabled, Oracle will write OS audit trail at OS … Continue reading How to enable auditing?