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.DV$ENFORCEMENT_AUDIT

Object Details

Object Name:	DV$ENFORCEMENT_AUDIT
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
OS_USER	VARCHAR2	(30)
USERID	VARCHAR2	(30)
HOST_NAME	VARCHAR2	(128)
TERMINAL	VARCHAR2	(30)
EVENT_TIMESTAMP	TIMESTAMP(6) WITH TIME ZONE	(20)
OBJ_OWNER	VARCHAR2	(30)
OBJ_NAME	VARCHAR2	(128)
DV_ACTION_CODE	NUMBER
DV_ACTION_NAME	VARCHAR2	(30)
DV_ACTION_OBJECT_NAME	VARCHAR2	(128)
SQL_TEXT	CLOB	(4000)
DV_RULE_SET_NAME	VARCHAR2	(90)
DV_FACTOR_CONTEXT	VARCHAR2	(4000)
DV_COMMENT	VARCHAR2	(4000)
SESSIONID	NUMBER
ENTRY_ID	NUMBER
STATEMENT_ID	NUMBER
DV_RETURN_CODE	NUMBER
PROXY_USERID	VARCHAR2	(30)
GLOBAL_USERID	VARCHAR2	(32)
INSTANCE_ID	NUMBER
OS_PROCESS	VARCHAR2	(16)
DV_GRANTEE	VARCHAR2	(30)
DV_OBJECT_STATUS	VARCHAR2	(1)

Query Text

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


SELECT OS_USER
,      USERID
,      HOST_NAME
,      TERMINAL
,      EVENT_TIMESTAMP
,      OBJ_OWNER
,      OBJ_NAME
,      DV_ACTION_CODE
,      DV_ACTION_NAME
,      DV_ACTION_OBJECT_NAME
,      SQL_TEXT
,      DV_RULE_SET_NAME
,      DV_FACTOR_CONTEXT
,      DV_COMMENT
,      SESSIONID
,      ENTRY_ID
,      STATEMENT_ID
,      DV_RETURN_CODE
,      PROXY_USERID
,      GLOBAL_USERID
,      INSTANCE_ID
,      OS_PROCESS
,      DV_GRANTEE
,      DV_OBJECT_STATUS
FROM SYS.DV$ENFORCEMENT_AUDIT;

Dependencies

[top of page]

SYS.DV$ENFORCEMENT_AUDIT references the following:

SYS.DV$ENFORCEMENT_AUDIT is not referenced by any database object