[Home] [Help] [Dependency Information]
Object Name: | DV$CONFIGURATION_AUDIT |
---|---|
Object Type: | VIEW |
Owner: | DVSYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID# | NUMBER | Yes | ||
OS_USERNAME | VARCHAR2 | (255) | ||
USERNAME | VARCHAR2 | (128) | ||
USERHOST | VARCHAR2 | (128) | ||
TERMINAL | VARCHAR2 | (255) | ||
TIMESTAMP | DATE | |||
OWNER | VARCHAR2 | (128) | ||
OBJ_NAME | VARCHAR2 | (128) | ||
ACTION | NUMBER | Yes | ||
ACTION_NAME | VARCHAR2 | (128) | ||
ACTION_OBJECT_ID | NUMBER | |||
ACTION_OBJECT_NAME | VARCHAR2 | (128) | ||
ACTION_COMMAND | VARCHAR2 | (4000) | ||
AUDIT_OPTION | VARCHAR2 | (4000) | ||
RULE_SET_ID | NUMBER | |||
RULE_SET_NAME | VARCHAR2 | (128) | ||
RULE_ID | NUMBER | |||
RULE_NAME | VARCHAR2 | (128) | ||
FACTOR_CONTEXT | VARCHAR2 | (4000) | ||
COMMENT_TEXT | VARCHAR2 | (4000) | ||
SESSIONID | NUMBER | Yes | ||
ENTRYID | NUMBER | Yes | ||
STATEMENTID | NUMBER | Yes | ||
RETURNCODE | NUMBER | Yes | ||
EXTENDED_TIMESTAMP | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
PROXY_SESSIONID | NUMBER | |||
GLOBAL_UID | VARCHAR2 | (32) | ||
INSTANCE_NUMBER | NUMBER | |||
OS_PROCESS | VARCHAR2 | (16) | ||
CREATED_BY | VARCHAR2 | (128) | ||
CREATE_DATE | DATE | |||
UPDATED_BY | VARCHAR2 | (128) | ||
UPDATE_DATE | DATE | |||
GRANTEE | VARCHAR2 | (128) | ||
ENABLED_STATUS | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ID#
, OS_USERNAME
, USERNAME
, USERHOST
, TERMINAL
, TIMESTAMP
, OWNER
, OBJ_NAME
, ACTION
, ACTION_NAME
, ACTION_OBJECT_ID
, ACTION_OBJECT_NAME
, ACTION_COMMAND
, AUDIT_OPTION
, RULE_SET_ID
, RULE_SET_NAME
, RULE_ID
, RULE_NAME
, FACTOR_CONTEXT
, COMMENT_TEXT
, SESSIONID
, ENTRYID
, STATEMENTID
, RETURNCODE
, EXTENDED_TIMESTAMP
, PROXY_SESSIONID
, GLOBAL_UID
, INSTANCE_NUMBER
, OS_PROCESS
, CREATED_BY
, CREATE_DATE
, UPDATED_BY
, UPDATE_DATE
, GRANTEE
, ENABLED_STATUS
FROM DVSYS.DV$CONFIGURATION_AUDIT;
DVSYS.DV$CONFIGURATION_AUDIT is not referenced by any database object
|
|
|