eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.UNIFIED_AUDIT_TRAIL

Object Details

Object Name:	UNIFIED_AUDIT_TRAIL
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

All audit trail entries

[View Source]

Columns

Name	Datatype	Length	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

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
FROM SYS.UNIFIED_AUDIT_TRAIL;

Dependencies

[top of page]

SYS.UNIFIED_AUDIT_TRAIL references the following:

SYS: ALL_UNIFIED_AUDIT_ACTIONS; STMT_AUDIT_OPTION_MAP; SYSTEM_PRIVILEGE_MAP

SYS.UNIFIED_AUDIT_TRAIL is referenced by following:

PUBLIC: UNIFIED_AUDIT_TRAIL