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(16)

 

Type of the auditing option. The possible values are SYSTEM PRIVILEGE, SYSTEM ACTION, OBJECT ACTION, ROLE PRIVILEGE, and INVALID.

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.