3.173 AUDIT_UNIFIED_POLICIES

AUDIT_UNIFIED_POLICIES describes all audit policies created in the database.

Note:

This view is populated only in an Oracle 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:

  • SYSTEM PRIVILEGE

  • STANDARD ACTION

  • SYSTEM ACTION

  • XS ACTION

  • OLS_ACTION

  • DATAPUMP ACTION

  • DIRECT LOAD ACTION

  • DV ACTION

  • INVALID

  • OBJECT ACTION

  • ROLE PRIVILEGE

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_TOPLEVELFoot 1

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)

Footnote 1 This column is available starting with Oracle Database release 19c, version 19.1.