Check unified audit in Oracle 12c

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             

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.