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_FGA_AUDIT_TRAIL

Object Details

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

All fine grained audit event logs

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	NUMBER		Yes	Session id of the query
TIMESTAMP	DATE			Date/Time of the query in the session time zone
DB_USER	VARCHAR2	(30)		Database username who executes the query
OS_USER	VARCHAR2	(255)		OS username who executes the query
USERHOST	VARCHAR2	(128)		Client host machine name
CLIENT_ID	VARCHAR2	(64)		Client identifier in each Oracle session
ECONTEXT_ID	VARCHAR2	(64)		Execution Context Identifier for each action
EXT_NAME	VARCHAR2	(4000)		External name
OBJECT_SCHEMA	VARCHAR2	(30)		Owner of the table or view
OBJECT_NAME	VARCHAR2	(128)		Name of the table or view
POLICY_NAME	VARCHAR2	(30)		Name of Fine Grained Auditing Policy
SCN	NUMBER			SCN of the query
SQL_TEXT	NVARCHAR2	(4000)		SQL text of the query
SQL_BIND	NVARCHAR2	(4000)		Bind variable data of the query
COMMENT$TEXT	VARCHAR2	(4000)		Comments
STATEMENT_TYPE	VARCHAR2	(7)		Statement Type of the query
EXTENDED_TIMESTAMP	TIMESTAMP(6) WITH TIME ZONE	(20)		Timestamp of the query in the session time zone
PROXY_SESSIONID	NUMBER			Proxy session serial number, if enterprise user has logged in through proxy mechanism
GLOBAL_UID	VARCHAR2	(32)		Global user identifier for the user, if the user had logged in as enterprise user
INSTANCE_NUMBER	NUMBER			Instance number as specified in initialization parameter file 'init.ora'
OS_PROCESS	VARCHAR2	(16)		Operating System process identifier of the Oracle server process
TRANSACTIONID	RAW	(8)		Transaction identifier of the transaction in which the object is accessed or modified
STATEMENTID	NUMBER			Numeric ID for each statement run (a statement may cause many actions)
ENTRYID	NUMBER			Numeric ID for each audit trail entry in the session
OBJ_EDITION_NAME	VARCHAR2	(30)		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 SESSION_ID
,      TIMESTAMP
,      DB_USER
,      OS_USER
,      USERHOST
,      CLIENT_ID
,      ECONTEXT_ID
,      EXT_NAME
,      OBJECT_SCHEMA
,      OBJECT_NAME
,      POLICY_NAME
,      SCN
,      SQL_TEXT
,      SQL_BIND
,      COMMENT$TEXT
,      STATEMENT_TYPE
,      EXTENDED_TIMESTAMP
,      PROXY_SESSIONID
,      GLOBAL_UID
,      INSTANCE_NUMBER
,      OS_PROCESS
,      TRANSACTIONID
,      STATEMENTID
,      ENTRYID
,      OBJ_EDITION_NAME
,      DBID
FROM SYS.DBA_FGA_AUDIT_TRAIL;

Dependencies

[top of page]

SYS.DBA_FGA_AUDIT_TRAIL references the following:

SYS: FGA_LOG$

SYS.DBA_FGA_AUDIT_TRAIL is referenced by following:

PUBLIC: DBA_FGA_AUDIT_TRAIL
SYS: DBA_COMMON_AUDIT_TRAIL