Skip to content

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

VIEW: SYS.GV_$UNIFIED_AUDIT_TRAIL

Object Details
Object Name: GV_$UNIFIED_AUDIT_TRAIL
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INST_ID NUMBER

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)
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_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

Query Text

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


SELECT INST_ID
,      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.GV_$UNIFIED_AUDIT_TRAIL;

Dependencies

[top of page]

SYS.GV_$UNIFIED_AUDIT_TRAIL references the following:

SYS.GV_$UNIFIED_AUDIT_TRAIL is referenced by following:

SchemaPUBLIC
SynonymGV$UNIFIED_AUDIT_TRAIL