Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_FGA_AUDIT_TRAIL

All fine grained audit event logs

Columns
   ___________________________
 
   SESSION_ID
      Session id of the query
   TIMESTAMP
      Time of the query
   DB_USER
      Database username who executes the query
   OS_USER
      OS username who executes the query
   USERHOST
      Numeric instance ID for the Oracle instance from which the user is accessing the database. Used only in environments with distributed file systems and shared database files (e.g.,clustered Oracle on DEC VAX/VMS clusters)
   CLIENT_ID
      Client identifier in each Oracle session
   EXT_NAME
      External name
   OBJECT_SCHEMA
      Owner of the table or view
   OBJECT_NAME
      Name of the table or view
   POLICY_NAME
      Name of Fine Grained Auditing Policy
   SCN
      SCN of the query
   SQL_TEXT
      SQL text of the query
   SQL_BIND
      Bind variable data of the query
   COMMENT$TEXT
      Comments

Related:



Simon Sheppard
SS64.com