3.176 AUDIT_UNIFIED_POLICIES

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^Foot 1

VARCHAR2(3)

Indicates whether the audit policy was inherited from another container (YES) or not (NO). It is NULL for non-CDBs.