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

VIEW: SYS.CDB_FGA_AUDIT_TRAIL

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

All fine grained audit event logs in all containers

[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 (128)
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 (128)
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 (128)
Owner of the table or view
OBJECT_NAME VARCHAR2 (128)
Name of the table or view
POLICY_NAME VARCHAR2 (128)
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 (128)
Edition containing audited object
DBID NUMBER

Database Identifier of the audited database
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_FGA_AUDIT_TRAIL;

Dependencies

[top of page]

SYS.CDB_FGA_AUDIT_TRAIL does not reference any database object

SYS.CDB_FGA_AUDIT_TRAIL is referenced by following:

SchemaPUBLIC
SynonymCDB_FGA_AUDIT_TRAIL