USER_NAME

VARCHAR2(128)

Username of the database user for whom the audit policy is enabled. If the audit policy is enabled for all users, then the value is ALL USERS.

This column is NULL for audit policies that are enabled on granted role.

This column is deprecated in Oracle Database 12c Release 2 (12.2.0.1), and may be removed in a future release.

POLICY_NAME

VARCHAR2(128)

Name of the audit policy

ENABLED_OPT

VARCHAR2(7)

Enabled option of the audit policy. Possible values:

• BY: For policies that are enabled on users

• EXCEPT: For policies that are enabled on users

• INVALID: For policies that are enabled on roles

This column is deprecated in Oracle Database 12c Release 2 (12.2.0.1), and may be removed in a future release.

ENABLED_OPTION

VARCHAR2(15)

Enabled option of the audit policy. Possible values:

• BY USER: For policies that are enabled on users

• EXCEPT USERS: For policies that are enabled on users

• BY GRANTED ROLE: For policies that are enabled on roles

• INVALID: For policies that are enabled on roles

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

ENTITY_NAME

VARCHAR2(128)

Database entity (user name or role name) on which the audit policy is enabled

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

ENTITY_TYPE

VARCHAR2(7)

Database entity type. Possible values:

• USER: Indicates that the policy is enabled on a user or users.

• ROLE: Indicates that the policy is enabled on a role or roles.

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

SUCCESS

VARCHAR2(3)

Indicates whether the audit policy is enabled for auditing successful events (YES) or not (NO)

FAILURE

VARCHAR2(3)

Indicates whether the audit policy is enabled for auditing unsuccessful events (YES) or not (NO)