Script for generate policy DDL in UNIFIED AUDIT POLICES
set serveroutput on
set long 20000
Declare
Begin
for policy_rec in (select unique policy_name from AUDIT_UNIFIED_POLICIES)
where policy_name not in ('ORA_ACCOUNT_MGMT','ORA_DATABASE_PARAMETER','ORA_SECURECONFIG',
'ORA_DV_AUDPOL','ORA_DV_AUDPOL2','ORA_RAS_POLICY_MGMT','ORA_RAS_SESSION_MGMT','ORA_LOGON_FAILURES',
'ORA_STIG_RECOMMENDATIONS','ORA_LOGON_LOGOFF','ORA_ALL_TOPLEVEL_ACTIONS','ORA_CIS_RECOMMENDATIONS')order by policy_name)
loop
dbms_output.put_line('POLICY_NAME '|| policy_rec.policy_name);
dbms_output.put_line('----------------------------------------');
DBMS_METADATA.GET_DDL('AUDIT_POLICY',policy_rec.policy_name);
end loop;
end;
/
I think there is a typo error
LikeLike