DBA Data[Home] [Help]

SYS.DBMS_FEATURE_UNIFIED_AUDIT dependencies on AUD_POLICY$

Line 36: select count(*) into unified_policies from aud_policy$;

32: select count(*) into uniaud_linkon from v$option
33: where parameter like '%Unified Auditing%' and value = 'TRUE';
34:
35: -- Get number of Unified Audit policies created in the database
36: select count(*) into unified_policies from aud_policy$;
37:
38: -- Get number of Unified Audit policies enabled in the database
39: select count(distinct policy#) into unified_policies_enb from audit_ng$;
40:

Line 42: select count(*) into unified_policies_cond from aud_policy$

38: -- Get number of Unified Audit policies enabled in the database
39: select count(distinct policy#) into unified_policies_enb from audit_ng$;
40:
41: -- Get number of Unified Audit policies with condition
42: select count(*) into unified_policies_cond from aud_policy$
43: where condition is NOT NULL;
44:
45: -- Get number of Unified Audit policies for each componenet
46: FOR item IN (SELECT audit_option_type, count(distinct policy_name) pol_cnt