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

VIEW: SYS.CDB_UNIFIED_AUDIT_TRAIL

Object Details
Object Name: CDB_UNIFIED_AUDIT_TRAIL
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All audit trail entries in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
AUDIT_TYPE VARCHAR2 (64)
Type of the Audit Record
SESSIONID NUMBER

Audit Session Identifier of the User session
PROXY_SESSIONID NUMBER

Proxy Audit Session Identifier in case of Proxy User session
OS_USERNAME VARCHAR2 (30)
Operating System logon user name of the user whose actions were audited
USERHOST VARCHAR2 (128)
Client host machine name
TERMINAL VARCHAR2 (30)
Identifier for the user's terminal
INSTANCE_ID NUMBER

Instance number as specified in the initialization parameter file 'init.ora'
DBID NUMBER

Database Identifier of the audited database
AUTHENTICATION_TYPE VARCHAR2 (1024)
Type of Authentication for the session user
DBUSERNAME VARCHAR2 (30)
Name of the user whose actions were audited
DBPROXY_USERNAME VARCHAR2 (30)
Name of the Proxy User in case of Proxy User sessions
EXTERNAL_USERID VARCHAR2 (1024)
External Identifier for externally authenticated users
GLOBAL_USERID VARCHAR2 (32)
Global user identifier for the user, if the user had logged in as enterprise user
CLIENT_PROGRAM_NAME VARCHAR2 (48)
Client Program Name which issued the commands in user session
DBLINK_INFO VARCHAR2 (4000)
Value of SYS_CONTEXT('USERENV', 'DBLINK_INFO')
XS_USER_NAME VARCHAR2 (128)
Real Application User name
XS_SESSIONID RAW (33)
Real Application User Session Identifier
ENTRY_ID NUMBER

Numeric ID for each audit trail entry in the session
STATEMENT_ID NUMBER

Numeric ID for each statement run (a statement may cause many actions)
EVENT_TIMESTAMP TIMESTAMP(6) WITH LOCAL TIME ZONE (20)
Timestamp of the creation of audit trail entry in session's time zone
ACTION_NAME VARCHAR2 (64)
Name of the action executed by the user
RETURN_CODE NUMBER

Oracle error code generated by the action. Zero if the action succeeded
OS_PROCESS VARCHAR2 (16)
Operating System process identifier of the Oracle server process
TRANSACTION_ID RAW (8)
Transaction identifier of the transaction in which the object is accessed or modified
SCN NUMBER

SCN (System Change Number) of the query
EXECUTION_ID VARCHAR2 (64)
Execution Context Identifier for each action
OBJECT_SCHEMA VARCHAR2 (30)
Schema name of object affected by the action
OBJECT_NAME VARCHAR2 (128)
Name of the object affected by the action
SQL_TEXT CLOB (4000)
SQL_BINDS CLOB (4000)
Bind variable data of the query
APPLICATION_CONTEXTS VARCHAR2 (4000)
SemiColon seperate list of Application Context Namespace, Attribute, Value information in (APPCTX_NSPACE,APPCTX_ATTRIBUTE=) format
CLIENT_IDENTIFIER VARCHAR2 (64)
Client identifier in each Oracle session
NEW_SCHEMA VARCHAR2 (30)
The schema of the object named in the NEW_NAME column
NEW_NAME VARCHAR2 (128)
New name of object after RENAME, or name of underlying object (e.g. CREATE INDEX owner.obj_name ON new_owner.new_name)
OBJECT_EDITION VARCHAR2 (30)
The edition of the object affected by the action
SYSTEM_PRIVILEGE_USED VARCHAR2 (1024)
System privilege used to execute the action
SYSTEM_PRIVILEGE VARCHAR2 (40)
Role granted/revoked/set by a GRANT/REVOKE/SET ROLE statement
AUDIT_OPTION VARCHAR2 (40)
Auditing option set with the audit statement
OBJECT_PRIVILEGES VARCHAR2 (19)
Object privileges granted/revoked by a GRANT/REVOKE statement
ROLE VARCHAR2 (30)
TARGET_USER VARCHAR2 (30)
User on whom the GRANT/REVOKE/AUDIT/NOAUDIT statement was executed
EXCLUDED_USER VARCHAR2 (30)
User who was excluded when the AUDIT/NOAUDIT statement was executed
EXCLUDED_SCHEMA VARCHAR2 (30)
Schema of EXCLUDED_OBJECT
EXCLUDED_OBJECT VARCHAR2 (128)
Object which was excluded when the SET ROLE/ALTER PLUGGABLE DATABASE statement was executed
ADDITIONAL_INFO VARCHAR2 (4000)
Text comment on the audit trail entry
UNIFIED_AUDIT_POLICIES VARCHAR2 (4000)
Unified Audit Policies that caused the audit trail entry
FGA_POLICY_NAME VARCHAR2 (30)
Fine-Grained Audit Policy that caused the audit trail entry
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 Record Id
RMAN_SESSION_STAMP NUMBER

RMAN Session Stamp
RMAN_OPERATION VARCHAR2 (20)
RMAN Operation
RMAN_OBJECT_TYPE VARCHAR2 (20)
RMAN Object Involved
RMAN_DEVICE_TYPE VARCHAR2 (5)
Device Involved in RMAN Session
DP_TEXT_PARAMETERS1 VARCHAR2 (512)
Audited DataPump parameters that have text values
DP_BOOLEAN_PARAMETERS1 VARCHAR2 (512)
Audited DataPump parameters that have boolean values
DIRECT_PATH_NUM_COLUMNS_LOADED NUMBER

Direct Path API load - number of columns loaded
CON_ID NUMBER

container id
Query Text

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


SELECT AUDIT_TYPE
,      SESSIONID
,      PROXY_SESSIONID
,      OS_USERNAME
,      USERHOST
,      TERMINAL
,      INSTANCE_ID
,      DBID
,      AUTHENTICATION_TYPE
,      DBUSERNAME
,      DBPROXY_USERNAME
,      EXTERNAL_USERID
,      GLOBAL_USERID
,      CLIENT_PROGRAM_NAME
,      DBLINK_INFO
,      XS_USER_NAME
,      XS_SESSIONID
,      ENTRY_ID
,      STATEMENT_ID
,      EVENT_TIMESTAMP
,      ACTION_NAME
,      RETURN_CODE
,      OS_PROCESS
,      TRANSACTION_ID
,      SCN
,      EXECUTION_ID
,      OBJECT_SCHEMA
,      OBJECT_NAME
,      SQL_TEXT
,      SQL_BINDS
,      APPLICATION_CONTEXTS
,      CLIENT_IDENTIFIER
,      NEW_SCHEMA
,      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.CDB_UNIFIED_AUDIT_TRAIL;

Dependencies

[top of page]

SYS.CDB_UNIFIED_AUDIT_TRAIL does not reference any database object

SYS.CDB_UNIFIED_AUDIT_TRAIL is referenced by following:

SchemaPUBLIC
SynonymCDB_UNIFIED_AUDIT_TRAIL