6.158 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	NULL	Description
USER_NAMEFoot 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_OPTFoot 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	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	VARCHAR2(128)		Database entity (user name or role name) on which the audit policy is enabled
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.
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.

See Also:

Oracle Database Security Guide for more information about auditing