{8 監査ポリシー}監査ポリシーを作成

 

https://docs.oracle.com/cd/F19136_01/dbseg/configuring-audit-policies.html#GUID-5E618BEF-A197-4A9F-B856-5D2941DFB4E5

     システム権限の監査
     オブジェクトアクションの監査
     ロールの監査
     
sqlplus test/test@pdb11

select * from AUDIT_UNIFIED_ENABLED_POLICIES;
select * from AUDIT_UNIFIED_POLICIES where POLICY_NAME like 'POLICY%';

CREATE AUDIT POLICY policy1
 PRIVILEGES DROP ANY TABLE, DROP ANY CONTEXT, DROP ANY INDEX, DROP ANY LIBRARY;

CREATE AUDIT POLICY policy2 ACTIONS SELECT ON SYS.USER$;

CREATE AUDIT POLICY policy3 
 ROLES DBA
 CONTAINER = current;