6.155 DBA_XS_ENABLED_AUDIT_POLICIES

DBA_XS_ENABLED_AUDIT_POLICIES describes all the audit policies specific to Oracle Database Real Application Security that are enabled to users.

Note:

This view was known as DBA_XS_ENB_AUDIT_POLICIES in Oracle Database 12c Release 1. It was renamed to DBA_XS_ENABLED_AUDIT_POLICIES in Oracle Database 12c Release 2 (12.2.0.1).

Column	Datatype	Description
`USER_NAME`^Foot 1	`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.
`POLICY_NAME`	`VARCHAR2(128)`	Name of the audit policy
`ENABLED_OPT`^Footref 1	`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
`ENABLED_OPTION`^Foot 2	`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
`ENTITY_NAME`^Footref 2	`VARCHAR2(128)`	Database entity (user name or role name) on which the audit policy is enabled
`ENTITY_TYPE`^Footref 2	`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.
`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`)

^Footnote 1

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

^Footnote 2

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