eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.AUDIT_UNIFIED_ENABLED_POLICIES

Object Details

Object Name:	AUDIT_UNIFIED_ENABLED_POLICIES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Describes the Audit policy's enablement to users

[View Source]

Columns

Name	Datatype	Length	Comments
USER_NAME	VARCHAR2	(128)	Database username for whom the Audit policy is enabled
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
FAILURE	VARCHAR2	(3)	Is the Audit policy enabled for auditing unsuccessful events

Query Text

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


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

Dependencies

[top of page]

SYS.AUDIT_UNIFIED_ENABLED_POLICIES references the following:

SYS: AUDIT_NG$; OBJ$; USER$

SYS.AUDIT_UNIFIED_ENABLED_POLICIES is referenced by following:

PUBLIC: AUDIT_UNIFIED_ENABLED_POLICIES
SYS: DBA_XS_ENB_AUDIT_POLICIES