Check unified audit in Oracle 12c
Unified auditing is new feature added in Oracle 12c based on memory.
Check the Unified auditing is enabled or Disable
COLUMN parameter format A20
COLUMN value format A10
select parameter,value from v$option where parameter = 'Unified Auditing';
PARAMETER VALUE
-------------------- ----------
Unified Auditing FALSE
Check the data present in Unified Auditing
select count(*) from unified_audit_trail;
Check Unified auditing options enabled in the database
COLUMN user_name format a10
COLUMN policy_name FORMAT A25
COLUMN success format a10
COLUMN failure format a10
select user_name,policy_name,enabled_opt,success,failure from audit_unified_enabled_policies;
USER_NAME POLICY_NAME ENABLED_ SUCCESS FAILURE
---------- ------------------------- -------- ---------- ----------
ALL USERS ORA_SECURECONFIG BY YES YES
Note: It show only one policy is enabled ORA_SECURECONFIG
For disable ORA_SECURECONFIG Policy
NOAUDIT POLICY ORA_SECURECONFIG;
For Delete Policy
drop audit policy POL1;
Check all the Unified auditing options available across the database
COLUMN policy_name FORMAT A25
COLUMN audit_option FORMAT A30
COLUMN object_schema FORMAT A15
COLUMN object_name FORMAT A15
COLUMN audit_option_type FORMAT A20
COLUMN audit_condition FORMAT A20
select policy_name,audit_option,object_schema,object_name, audit_option_type,audit_condition FROM audit_unified_policies where object_schema not in ('DVSYS','DVF','LBACSYS');
POLICY_NAME AUDIT_OPTION OBJECT_SCHEMA OBJECT_NAME AUDIT_OPTION_TYPE AUDIT_CONDITION ------------------------- ------------------------------ --------------- ------------ -------------------- ----------------- ORA_SECURECONFIG LOGMINING NONE NONE SYSTEM PRIVILEGE NONE ORA_SECURECONFIG TRANSLATE ANY SQL NONE NONE SYSTEM PRIVILEGE NONE ORA_SECURECONFIG EXEMPT REDACTION POLICY NONE NONE SYSTEM PRIVILEGE NONE ORA_SECURECONFIG PURGE DBA_RECYCLEBIN NONE NONE SYSTEM PRIVILEGE NONE ORA_SECURECONFIG ADMINISTER KEY MANAGEMENT NONE NONE SYSTEM PRIVILEGE NONE ..................... ..................... ORA_SECURECONFIG GRANT ANY PRIVILEGE NONE NONE SYSTEM PRIVILEGE NONE ORA_SECURECONFIG DROP ANY PROCEDURE NONE NONE SYSTEM PRIVILEGE NONE