How to Verify, View, and Turn Off Oracle 12c Audits

After you turn on auditing in the database, keep track of the audits that you enact so you know what you’ve done. Luckily, Oracle 12c provides a few views in the database to help you keep track of your actions:

To verify what system privileges you configured for auditing, use the view AUDIT_UNIFIED_POLICIES.

To see what privileges are being audited by default for specific policies, type

The last two columns, SUC and FAI, stand for SUCCESS or FAILURE. You can capture an audit for SUCCESS or FAILURE or both. The policy you created, DROP_ANY_TABLE_FAIL_POLICY, captures only the times when a drop table fails.

How to view audit information with Oracle 12c

After configuring for and turning on auditing, see what audit data is being collected.