AUDIT_UNIFIED_POLICIES

AUDIT_UNIFIED_POLICIES describes all audit policies created in the database.

Note:

This view is populated only in an Oracle AI Database where unified auditing is enabled.

Column Datatype NULL Description
POLICY_NAME VARCHAR2(128)   Name of the audit policy
AUDIT_CONDITION VARCHAR2(4000)   Condition associated with the audit policy
CONDITION_EVAL_OPT VARCHAR2(9)   Evaluation option associated with the audit policy’s condition. The possible values are STATEMENT, SESSION, INSTANCE, and NONE.
AUDIT_OPTION VARCHAR2(128)   Auditing option defined in the audit policy
AUDIT_OPTION_TYPE VARCHAR2(18)  

Type of the auditing option. Possible values:

  • COLUMN ACTION

  • DATAPUMP ACTION

  • DIRECT LOAD ACTION

  • DV ACTION

  • INVALID

  • OBJECT ACTION

  • OLS_ACTION

  • ROLE PRIVILEGE

  • STANDARD ACTION

  • SYSTEM ACTION

  • SYSTEM PRIVILEGE

  • XS ACTION
OBJECT_SCHEMA VARCHAR2(128)   Owner of the object, for an object-specific auditing option
OBJECT_NAME VARCHAR2(128)   Name of the object, for an object-specific auditing option
OBJECT_TYPE VARCHAR2(23)   Type of the object, for an object-specific auditing option
COMMON VARCHAR2(3)  

Indicates whether the audit policy is a common audit policy or local audit policy. The value is NULL for a non-CDB.

For local audit policies, the value of the COMMON column is always NO.

For a CDB common policy:

  • If you query AUDIT_UNIFIED_POLICIES from the CDB root container, the value of the COMMON column will be YES and the value of the INHERITED column will be NO.

  • If you query AUDIT_UNIFIED_POLICIES from any other container besides the CDB root container, the value of the COMMON column and the INHERITED column will be YES.

For an application container common policy:

  • If you query AUDIT_UNIFIED_POLICIES from the application root container, the value of the COMMON column will be YES and the value of the INHERITED column will be NO.

  • If you query AUDIT_UNIFIED_POLICIES from any other container besides the application root container, the value of the COMMON column and the INHERITED column will be YES.

INHERITED VARCHAR2(3)   Indicates whether the audit policy was inherited from another container (YES) or not (NO). This value is NULL for non-CDBs.
AUDIT_ONLY_TOPLEVEL VARCHAR2(3)   Indicates whether the audit policy is defined to audit only top level SQL statements (YES) or both top level SQL statements and recursive SQL statements (NO)
ORACLE_SUPPLIED VARCHAR2(3)  

Indicates whether the audit policy is an Oracle-supplied policy (YES) or not (NO)

Oracle-supplied policies are also called predefined policies.
COLUMN_NAME VARCHAR2(128)  

If AUDIT_OPTION_TYPE = COLUMN ACTION, then this column displays the name of the table column on which the audit policy was created. In this case, the OBJECT_SCHEMA, OBJECT_NAME, and OBJECT_TYPE columns apply to the table containing the audited column.

Otherwise, the value of this column is null.