[Home] [Help] [Dependency Information]
Object Name: | GV_$XML_AUDIT_TRAIL |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
AUDIT_TYPE | NUMBER | |||
SESSION_ID | NUMBER | |||
PROXY_SESSIONID | NUMBER | |||
STATEMENTID | NUMBER | |||
ENTRYID | NUMBER | |||
EXTENDED_TIMESTAMP | TIMESTAMP(6) WITH TIME ZONE | (20) | ||
GLOBAL_UID | VARCHAR2 | (32) | ||
DB_USER | VARCHAR2 | (30) | ||
CLIENTIDENTIFIER | VARCHAR2 | (64) | ||
EXT_NAME | VARCHAR2 | (1024) | ||
OS_USER | VARCHAR2 | (30) | ||
OS_HOST | VARCHAR2 | (128) | ||
OS_PROCESS | VARCHAR2 | (16) | ||
TERMINAL | VARCHAR2 | (30) | ||
INSTANCE_NUMBER | NUMBER | |||
OBJECT_SCHEMA | VARCHAR2 | (30) | ||
OBJECT_NAME | VARCHAR2 | (30) | ||
POLICY_NAME | VARCHAR2 | (30) | ||
NEW_OWNER | VARCHAR2 | (30) | ||
NEW_NAME | VARCHAR2 | (30) | ||
ACTION | NUMBER | |||
STATEMENT_TYPE | NUMBER | |||
TRANSACTIONID | RAW | (8) | ||
RETURNCODE | NUMBER | |||
SCN | NUMBER | |||
COMMENT_TEXT | VARCHAR2 | (4000) | ||
AUTH_PRIVILEGES | VARCHAR2 | (16) | ||
GRANTEE | VARCHAR2 | (30) | ||
PRIV_USED | NUMBER | |||
SES_ACTIONS | VARCHAR2 | (16) | ||
OS_PRIVILEGE | VARCHAR2 | (7) | ||
ECONTEXT_ID | VARCHAR2 | (64) | ||
SQL_BIND | VARCHAR2 | (4000) | ||
SQL_TEXT | VARCHAR2 | (4000) | ||
OBJ_EDITION_NAME | VARCHAR2 | (30) | ||
DBID | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, AUDIT_TYPE
, SESSION_ID
, PROXY_SESSIONID
, STATEMENTID
, ENTRYID
, EXTENDED_TIMESTAMP
, GLOBAL_UID
, DB_USER
, CLIENTIDENTIFIER
, EXT_NAME
, OS_USER
, OS_HOST
, OS_PROCESS
, TERMINAL
, INSTANCE_NUMBER
, OBJECT_SCHEMA
, OBJECT_NAME
, POLICY_NAME
, NEW_OWNER
, NEW_NAME
, ACTION
, STATEMENT_TYPE
, TRANSACTIONID
, RETURNCODE
, SCN
, COMMENT_TEXT
, AUTH_PRIVILEGES
, GRANTEE
, PRIV_USED
, SES_ACTIONS
, OS_PRIVILEGE
, ECONTEXT_ID
, SQL_BIND
, SQL_TEXT
, OBJ_EDITION_NAME
, DBID
, CON_ID
FROM SYS.GV_$XML_AUDIT_TRAIL;
|
|
|