← Security
Oracle · Security

How to list enabled Unified Auditing policies in Oracle

List which Unified Auditing policies are currently enabled and for whom, from AUDIT_UNIFIED_ENABLED_POLICIES.

Tested on12c18c19c21c23ai26ai

List the Unified Auditing policies that are currently enabled, for which users, and whether they capture successes, failures, or both.

SELECT policy_name, enabled_option, entity_name, entity_type,
       success, failure
FROM   audit_unified_enabled_policies
ORDER  BY policy_name, entity_name;
SecurityAuditingAudit Policies