DBA Data[Home] [Help] [Dependency Information]


VIEW: SYS.DBA_XS_ENB_AUDIT_POLICIES

Object Details
Object Name: DBA_XS_ENB_AUDIT_POLICIES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Describes all XS related audit policy's enablement to users

[View Source]

Columns
Name Datatype Length Mandatory Comments
USER_NAME VARCHAR2 (128)
Database username for whom the Audit policy is enabled. If the audit policy is enabled for all users, then the value is ALL USERS
POLICY_NAME VARCHAR2 (128)
Name of the Audit policy
ENABLED_OPT VARCHAR2 (8)
Enabled option of the Audit policy. The possible values are BY, EXCEPT, DISABLED
SUCCESS VARCHAR2 (3)
Is the Audit policy enabled for auditing successful events. The possible values are YES or NO
FAILURE VARCHAR2 (3)
Is the Audit policy enabled for auditing unsuccessful events.The possible values are YES or NO
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USER_NAME
,      POLICY_NAME
,      ENABLED_OPT
,      SUCCESS
,      FAILURE
FROM SYS.DBA_XS_ENB_AUDIT_POLICIES;

Dependencies

[top of page]

SYS.DBA_XS_ENB_AUDIT_POLICIES references the following:

SchemaSYS
ViewAUDIT_UNIFIED_ENABLED_POLICIES
ViewAUDIT_UNIFIED_POLICIES
SYS.DBA_XS_ENB_AUDIT_POLICIES is referenced by following:

SchemaPUBLIC
SynonymDBA_XS_ENB_AUDIT_POLICIES