[Home] [Help] [Dependency Information]
Object Name: | V_$UNIFIED_AUDIT_TRAIL |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUDIT_TYPE | NUMBER | |||
SESSIONID | NUMBER | |||
PROXY_SESSIONID | NUMBER | |||
OS_USER | VARCHAR2 | (30) | ||
HOST_NAME | VARCHAR2 | (128) | ||
TERMINAL | VARCHAR2 | (30) | ||
INSTANCE_ID | NUMBER | |||
DBID | NUMBER | |||
AUTHENTICATION_TYPE | VARCHAR2 | (1024) | ||
USERID | VARCHAR2 | (30) | ||
PROXY_USERID | VARCHAR2 | (30) | ||
EXTERNAL_USERID | VARCHAR2 | (1024) | ||
GLOBAL_USERID | VARCHAR2 | (32) | ||
CLIENT_PROGRAM_NAME | VARCHAR2 | (48) | ||
DBLINK_INFO | VARCHAR2 | (4000) | ||
XS_USER_NAME | VARCHAR2 | (128) | ||
XS_SESSIONID | RAW | (33) | ||
ENTRY_ID | NUMBER | |||
STATEMENT_ID | NUMBER | |||
EVENT_TIMESTAMP | TIMESTAMP(6) WITH TIME ZONE | (20) | ||
ACTION | NUMBER | |||
RETURN_CODE | NUMBER | |||
OS_PROCESS | VARCHAR2 | (16) | ||
TRANSACTION_ID | RAW | (8) | ||
SCN | NUMBER | |||
EXECUTION_ID | VARCHAR2 | (64) | ||
OBJ_OWNER | VARCHAR2 | (30) | ||
OBJ_NAME | VARCHAR2 | (128) | ||
SQL_TEXT | CLOB | (4000) | ||
SQL_BINDS | CLOB | (4000) | ||
APPLICATION_CONTEXTS | VARCHAR2 | (4000) | ||
CLIENT_IDENTIFIER | VARCHAR2 | (64) | ||
NEW_OWNER | VARCHAR2 | (30) | ||
NEW_NAME | VARCHAR2 | (128) | ||
OBJECT_EDITION | VARCHAR2 | (30) | ||
SYSTEM_PRIVILEGE_USED | VARCHAR2 | (1024) | ||
SYSTEM_PRIVILEGE | NUMBER | |||
AUDIT_OPTION | NUMBER | |||
OBJECT_PRIVILEGES | VARCHAR2 | (19) | ||
ROLE | VARCHAR2 | (30) | ||
TARGET_USER | VARCHAR2 | (30) | ||
EXCLUDED_USER | VARCHAR2 | (30) | ||
EXCLUDED_SCHEMA | VARCHAR2 | (30) | ||
EXCLUDED_OBJECT | VARCHAR2 | (128) | ||
ADDITIONAL_INFO | VARCHAR2 | (4000) | ||
UNIFIED_AUDIT_POLICIES | VARCHAR2 | (4000) | ||
FGA_POLICY_NAME | VARCHAR2 | (30) | ||
XS_INACTIVITY_TIMEOUT | NUMBER | |||
XS_ENTITY_TYPE | VARCHAR2 | (32) | ||
XS_TARGET_PRINCIPAL_NAME | VARCHAR2 | (30) | ||
XS_PROXY_USER_NAME | VARCHAR2 | (30) | ||
XS_DATASEC_POLICY_NAME | VARCHAR2 | (30) | ||
XS_SCHEMA_NAME | VARCHAR2 | (30) | ||
XS_CALLBACK_EVENT_TYPE | VARCHAR2 | (32) | ||
XS_PACKAGE_NAME | VARCHAR2 | (30) | ||
XS_PROCEDURE_NAME | VARCHAR2 | (30) | ||
XS_ENABLED_ROLE | VARCHAR2 | (30) | ||
XS_COOKIE | VARCHAR2 | (1024) | ||
XS_NS_NAME | VARCHAR2 | (30) | ||
XS_NS_ATTRIBUTE | VARCHAR2 | (4000) | ||
XS_NS_ATTRIBUTE_OLD_VAL | VARCHAR2 | (4000) | ||
XS_NS_ATTRIBUTE_NEW_VAL | VARCHAR2 | (4000) | ||
DV_ACTION_CODE | NUMBER | |||
DV_ACTION_NAME | VARCHAR2 | (30) | ||
DV_EXTENDED_ACTION_CODE | NUMBER | |||
DV_GRANTEE | VARCHAR2 | (30) | ||
DV_RETURN_CODE | NUMBER | |||
DV_ACTION_OBJECT_NAME | VARCHAR2 | (128) | ||
DV_RULE_SET_NAME | VARCHAR2 | (90) | ||
DV_COMMENT | VARCHAR2 | (4000) | ||
DV_FACTOR_CONTEXT | VARCHAR2 | (4000) | ||
DV_OBJECT_STATUS | VARCHAR2 | (1) | ||
OLS_POLICY_NAME | VARCHAR2 | (30) | ||
OLS_GRANTEE | VARCHAR2 | (30) | ||
OLS_MAX_READ_LABEL | VARCHAR2 | (4000) | ||
OLS_MAX_WRITE_LABEL | VARCHAR2 | (4000) | ||
OLS_MIN_WRITE_LABEL | VARCHAR2 | (4000) | ||
OLS_PRIVILEGES_GRANTED | VARCHAR2 | (30) | ||
OLS_PROGRAM_UNIT_NAME | VARCHAR2 | (30) | ||
OLS_PRIVILEGES_USED | VARCHAR2 | (128) | ||
OLS_STRING_LABEL | VARCHAR2 | (4000) | ||
OLS_LABEL_COMPONENT_TYPE | VARCHAR2 | (12) | ||
OLS_LABEL_COMPONENT_NAME | VARCHAR2 | (30) | ||
OLS_PARENT_GROUP_NAME | VARCHAR2 | (30) | ||
OLS_OLD_VALUE | VARCHAR2 | (4000) | ||
OLS_NEW_VALUE | VARCHAR2 | (4000) | ||
RMAN_SESSION_RECID | NUMBER | |||
RMAN_SESSION_STAMP | NUMBER | |||
RMAN_OPERATION | VARCHAR2 | (20) | ||
RMAN_OBJECT_TYPE | VARCHAR2 | (20) | ||
RMAN_DEVICE_TYPE | VARCHAR2 | (5) | ||
DP_TEXT_PARAMETERS1 | VARCHAR2 | (512) | ||
DP_BOOLEAN_PARAMETERS1 | VARCHAR2 | (512) | ||
DIRECT_PATH_NUM_COLUMNS_LOADED | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT AUDIT_TYPE
, SESSIONID
, PROXY_SESSIONID
, OS_USER
, HOST_NAME
, TERMINAL
, INSTANCE_ID
, DBID
, AUTHENTICATION_TYPE
, USERID
, PROXY_USERID
, EXTERNAL_USERID
, GLOBAL_USERID
, CLIENT_PROGRAM_NAME
, DBLINK_INFO
, XS_USER_NAME
, XS_SESSIONID
, ENTRY_ID
, STATEMENT_ID
, EVENT_TIMESTAMP
, ACTION
, RETURN_CODE
, OS_PROCESS
, TRANSACTION_ID
, SCN
, EXECUTION_ID
, OBJ_OWNER
, OBJ_NAME
, SQL_TEXT
, SQL_BINDS
, APPLICATION_CONTEXTS
, CLIENT_IDENTIFIER
, NEW_OWNER
, NEW_NAME
, OBJECT_EDITION
, SYSTEM_PRIVILEGE_USED
, SYSTEM_PRIVILEGE
, AUDIT_OPTION
, OBJECT_PRIVILEGES
, ROLE
, TARGET_USER
, EXCLUDED_USER
, EXCLUDED_SCHEMA
, EXCLUDED_OBJECT
, ADDITIONAL_INFO
, UNIFIED_AUDIT_POLICIES
, FGA_POLICY_NAME
, XS_INACTIVITY_TIMEOUT
, XS_ENTITY_TYPE
, XS_TARGET_PRINCIPAL_NAME
, XS_PROXY_USER_NAME
, XS_DATASEC_POLICY_NAME
, XS_SCHEMA_NAME
, XS_CALLBACK_EVENT_TYPE
, XS_PACKAGE_NAME
, XS_PROCEDURE_NAME
, XS_ENABLED_ROLE
, XS_COOKIE
, XS_NS_NAME
, XS_NS_ATTRIBUTE
, XS_NS_ATTRIBUTE_OLD_VAL
, XS_NS_ATTRIBUTE_NEW_VAL
, DV_ACTION_CODE
, DV_ACTION_NAME
, DV_EXTENDED_ACTION_CODE
, DV_GRANTEE
, DV_RETURN_CODE
, DV_ACTION_OBJECT_NAME
, DV_RULE_SET_NAME
, DV_COMMENT
, DV_FACTOR_CONTEXT
, DV_OBJECT_STATUS
, OLS_POLICY_NAME
, OLS_GRANTEE
, OLS_MAX_READ_LABEL
, OLS_MAX_WRITE_LABEL
, OLS_MIN_WRITE_LABEL
, OLS_PRIVILEGES_GRANTED
, OLS_PROGRAM_UNIT_NAME
, OLS_PRIVILEGES_USED
, OLS_STRING_LABEL
, OLS_LABEL_COMPONENT_TYPE
, OLS_LABEL_COMPONENT_NAME
, OLS_PARENT_GROUP_NAME
, OLS_OLD_VALUE
, OLS_NEW_VALUE
, RMAN_SESSION_RECID
, RMAN_SESSION_STAMP
, RMAN_OPERATION
, RMAN_OBJECT_TYPE
, RMAN_DEVICE_TYPE
, DP_TEXT_PARAMETERS1
, DP_BOOLEAN_PARAMETERS1
, DIRECT_PATH_NUM_COLUMNS_LOADED
, CON_ID
FROM SYS.V_$UNIFIED_AUDIT_TRAIL;
|
|
|