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.DBA_COMMON_AUDIT_TRAIL

Object Details

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

Combined Standard and Fine Grained audit trail entries

[View Source]

Columns

Name	Datatype	Length	Comments
AUDIT_TYPE	VARCHAR2	(22)	Audit trail type
SESSION_ID	NUMBER		Numeric id for the Oracle session
PROXY_SESSIONID	NUMBER		Proxy session serial number, if enterprise user has logged through proxy mechanism
STATEMENTID	NUMBER		Numeric id for the statement run (a statement may cause multiple audit records)
ENTRYID	NUMBER		Numeric id for the audit trail entry in the session
EXTENDED_TIMESTAMP	TIMESTAMP(6) WITH TIME ZONE	(20)	Timestamp of the audited operation (Timestamp of the user's logon for entries created by AUDIT SESSION) in session's time zone
GLOBAL_UID	VARCHAR2	(32)	Global user identifier for the user, if the user had logged in as enterprise user
DB_USER	VARCHAR2	(128)	Database username of the user whose actions were audited
CLIENT_ID	VARCHAR2	(128)	Client identifier in the Oracle session
ECONTEXT_ID	VARCHAR2	(64)	Execution Context Identifier for each action
EXT_NAME	VARCHAR2	(4000)	User external name
OS_USER	VARCHAR2	(255)	Operating System logon user name of the user whose actions were audited
USERHOST	VARCHAR2	(128)	Client host machine name
OS_PROCESS	VARCHAR2	(16)	Operating System process identifier of the Oracle server process
TERMINAL	VARCHAR2	(255)	Identifier for the user's terminal
INSTANCE_NUMBER	NUMBER		Instance number as specified in the initialization parameter file 'init.ora'
OBJECT_SCHEMA	VARCHAR2	(128)	Owner of the audited object
OBJECT_NAME	VARCHAR2	(128)	Name of the object affected by the action
POLICY_NAME	VARCHAR2	(30)	Name of Fine Grained Auditing Policy
NEW_OWNER	VARCHAR2	(128)	Owner 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)
ACTION	NUMBER		Numeric action type code
STATEMENT_TYPE	VARCHAR2	(28)	Action type corresponding to the numeric code in ACTION
AUDIT_OPTION	VARCHAR2	(40)	Auditing option set with the standard audit statement
TRANSACTIONID	RAW	(8)	Transaction identifier of the transaction in which the object is accessed or modified
RETURNCODE	NUMBER		Oracle error code generated by the action. Zero if the action succeeded
SCN	NUMBER		SCN (System Change Number) of the query
COMMENT_TEXT	VARCHAR2	(4000)	Text comment on the audit trail entry. Also indicates how the user was authenticated. The method can be one of the following: 1. "DATABASE" - authentication was done by password. 2. "NETWORK" - authentication was done by Net8 or the Advanced Networking Option. 3. "PROXY" - the client was authenticated by another user. The name of the proxy user follows the method type.
SQL_BIND	NVARCHAR2	(4000)	Bind variable data of the query
SQL_TEXT	NVARCHAR2	(4000)	SQL text of the query
OBJ_PRIVILEGE	VARCHAR2	(16)	Object privileges granted/revoked by a GRANT/REVOKE statement
SYS_PRIVILEGE	VARCHAR2	(40)	System privileges granted/revoked by a GRANT/REVOKE statement
ADMIN_OPTION	VARCHAR2	(1)	If role/sys_priv was granted WITH ADMIN OPTON, A/-
OS_PRIVILEGE	VARCHAR2	(7)	Operating Privilege (SYSDBA/SYSOPER) used in the session. If no privilege is used, it will be NONE
GRANTEE	VARCHAR2	(128)	The name of the grantee specified in a GRANT/REVOKE statement
PRIV_USED	VARCHAR2	(40)	System privilege used to perform the action
SES_ACTIONS	VARCHAR2	(19)	Session summary. A string of 12 characters, one for each action type, in thisorder: Alter, Audit, Comment, Delete, Grant, Index, Insert, Lock, Rename, Select, Update, Flashback. Values: "-" = None, "S" = Success, "F" = Failure, "B" = Both
LOGOFF_TIME	DATE		Timestamp for user logoff
LOGOFF_LREAD	NUMBER		Number of logical reads in the session
LOGOFF_PREAD	NUMBER		Number of physical reads in the session
LOGOFF_LWRITE	NUMBER		Number of logical writes of the session
LOGOFF_DLOCK	VARCHAR2	(40)	Number of deadlocks detected during the session
SESSION_CPU	NUMBER		Amount of cpu time used by the Oracle session
OBJ_EDITION_NAME	VARCHAR2	(128)	Edition containing audited object
DBID	NUMBER		Database Identifier of the audited database

Query Text

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


SELECT AUDIT_TYPE
,      SESSION_ID
,      PROXY_SESSIONID
,      STATEMENTID
,      ENTRYID
,      EXTENDED_TIMESTAMP
,      GLOBAL_UID
,      DB_USER
,      CLIENT_ID
,      ECONTEXT_ID
,      EXT_NAME
,      OS_USER
,      USERHOST
,      OS_PROCESS
,      TERMINAL
,      INSTANCE_NUMBER
,      OBJECT_SCHEMA
,      OBJECT_NAME
,      POLICY_NAME
,      NEW_OWNER
,      NEW_NAME
,      ACTION
,      STATEMENT_TYPE
,      AUDIT_OPTION
,      TRANSACTIONID
,      RETURNCODE
,      SCN
,      COMMENT_TEXT
,      SQL_BIND
,      SQL_TEXT
,      OBJ_PRIVILEGE
,      SYS_PRIVILEGE
,      ADMIN_OPTION
,      OS_PRIVILEGE
,      GRANTEE
,      PRIV_USED
,      SES_ACTIONS
,      LOGOFF_TIME
,      LOGOFF_LREAD
,      LOGOFF_PREAD
,      LOGOFF_LWRITE
,      LOGOFF_DLOCK
,      SESSION_CPU
,      OBJ_EDITION_NAME
,      DBID
FROM SYS.DBA_COMMON_AUDIT_TRAIL;

Dependencies

[top of page]

SYS.DBA_COMMON_AUDIT_TRAIL references the following:

SYS: AUDIT_ACTIONS; DBA_AUDIT_TRAIL; DBA_FGA_AUDIT_TRAIL; STMT_AUDIT_OPTION_MAP; SYSTEM_PRIVILEGE_MAP

SYS.DBA_COMMON_AUDIT_TRAIL is referenced by following:

PUBLIC: DBA_COMMON_AUDIT_TRAIL