← 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