All audit trail entries
Columns
___________________________
OS_USERNAME
Operating System logon user name of the user whose actions were audited
USERNAME
Name (not ID number) of the user whose actions were audited
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)
TERMINAL
Identifier for the user's terminal
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)
OBJ_PRIVILEGE
Object privileges granted/revoked by a GRANT/REVOKE statement
SYS_PRIVILEGE
System privileges granted/revoked by a GRANT/REVOKE statement
ADMIN_OPTION
If role/sys_priv was granted WITH ADMIN OPTON,A/-
GRANTEE
The name of the grantee specified in a GRANT/REVOKE statement
AUDIT_OPTION
Auditing option set with the audit statement
SES_ACTIONS
Session summary. A string of 11 characters,one for each action type,in this order: 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_PREAD
Physical 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 method can be one of thefollowing: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.
SESSIONID
Numeric ID for each Oracle session
ENTRYID
Numeric ID for each audit trail entry in the session
STATEMENTID
Numeric ID for each statement run (a statement may cause many actions)
RETURNCODE
Oracle error code generated by the action. Zero if the action succeeded
PRIV_USED
System privilege used to execute the action
CLIENT_ID
Client identifier in each Oracle session
SESSION_CPU
Amount cpu time used by each oracel session
Related: