DBA_AUDIT_TRAIL

Columns
   ___________________________
 
   RETURNCODE
      Oracle error code generated by the action.  Zero if the action succeeded
   LOGOFF_PREAD
      Physical reads for the session
   AUDIT_OPTION
      Auditing option set with the audit statement
   SES_ACTIONS
      Session summary.  A string of 11 characters, one for each action type, in thisorder: Alter, Audit, Comment, Delete, Grant, Index, Insert, Lock, Rename, Select, Update.  Values:  `-` = None, `S` = Success, `F` = Failure, `B` = Both
   LOGOFF_TIME
      Timestamp for user logoff
   LOGOFF_LREAD
      Logical reads for the session
   LOGOFF_LWRITE
      Logical writes for the session
   LOGOFF_DLOCK
      Deadlocks detected during the session
   COMMENT_TEXT
      Text comment on the audit trail entry.
      Also indicates how the user was authenticated.
      The authentication method can be one of:
         "DATABASE" - by password.
         "NETWORK"  - by Net8 or the Advanced Networking Option.
         "PROXY"    - by another user. The name of the proxy user follows the method type.
   SESSIONID
      Numeric ID for each Oracle session
   STATEMENTID
      Numeric ID for each statement run (a statement may cause many actions)
   OBJ_PRIVILEGE
      Object privileges granted/revoked by a GRANT/REVOKE statement
   PRIV_USED
      System privilege used to execute the action
   ENTRYID
      Numeric ID for each audit trail entry in the session
   TERMINAL
      Identifier for the user's terminal
   OS_USERNAME
      Operating System logon user name of the user whose actions were audited
   ADMIN_OPTION
      If role/sys_priv was granted WITH ADMIN OPTON, A/-
   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)
   GRANTEE
      The name of the grantee specified in a GRANT/REVOKE statement
   TIMESTAMP
      Timestamp for the creation of the audit trail entry (Timestamp for the user's logon for entries created by AUDIT SESSION)
   OWNER
      Creator of object affected by the action
   OBJ_NAME
      Name of the object affected by the action
   ACTION
      Numeric action type code.  The corresponding name of the action type (CREATE TABLE, INSERT, etc.) is in the column ACTION_NAME
   ACTION_NAME
      Name of the action type corresponding to the numeric code in ACTION
   NEW_OWNER
      The owner of the object named in the NEW_NAME column
   NEW_NAME
      New name of object after RENAME, or name of underlying object (e.g. CREATE INDEX owner.obj_name ON new_owner.new_name)
   SYS_PRIVILEGE
      System privileges granted/revoked by a GRANT/REVOKE statement
   USERNAME
      Name (not ID number) of the user whose actions were audited

Related Commands: