Unified audit policies present in db - Oracle Database Script. -- Audit policies present in db: select distinct POLICY_NAME from AUDIT_UNIFIED_POLICIES; -- Enabled audit policies in db: select distinct policy_name from AUDIT_UNIFIED_ENABLED_POLICIES; -- Get the audit options included in an policy select AUDIT_OPTION from AUDIT_UNIFIED_POLICIES where POLICY_NAME='ORA_SECURECONFIG';
-- Audit policies present in db: select distinct POLICY_NAME from AUDIT_UNIFIED_POLICIES; -- Enabled audit policies in db: select distinct policy_name from AUDIT_UNIFIED_ENABLED_POLICIES; -- Get the audit options included in an policy select AUDIT_OPTION from AUDIT_UNIFIED_POLICIES where POLICY_NAME='ORA_SECURECONFIG';