OS_USERNAME
|
VARCHAR2(255)
|
|
Operating system login username of the user whose actions were audited
|
USERNAME
|
VARCHAR2(30)
|
|
Name (not ID number) of the user whose actions were audited
|
USERHOST
|
VARCHAR2(128)
|
|
Numeric instance ID for the Oracle instance from which the user is accessing the database
|
TERMINAL
|
VARCHAR2(255)
|
|
Identifier of the user's terminal
|
TIMESTAMP
|
DATE
|
NOT NULL
|
Timestamp for the creation of the audit trail entry
|
OWNER
|
VARCHAR2(30)
|
|
Intended creator of the non-existent object
|
OBJ_NAME
|
VARCHAR2(128)
|
|
Name of the object affected by the action
|
ACTION_NAME
|
VARCHAR2(27)
|
|
Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL
|
NEW_OWNER
|
VARCHAR2(30)
|
|
Owner of the object named in the NEW_NAME column
|
NEW_NAME
|
VARCHAR2(128)
|
|
New name of an object after a RENAME or the name of the underlying object
|
OBJ_PRIVILEGE
|
VARCHAR2(16)
|
|
Object privileges granted or revoked by a GRANT or REVOKE statement
|
SYS_PRIVILEGE
|
VARCHAR2(40)
|
|
System privileges granted or revoked by a GRANT or REVOKE statement
|
GRANTEE
|
VARCHAR2(30)
|
|
Name of the grantee specified in a GRANT or REVOKE statement
|
SESSIONID
|
NUMBER
|
NOT NULL
|
Numeric ID for each Oracle session
|
ENTRYID
|
NUMBER
|
NOT NULL
|
Numeric ID for each audit trail entry in the session
|
STATEMENTID
|
NUMBER
|
NOT NULL
|
Numeric ID for each statement run
|
RETURNCODE
|
NUMBER
|
NOT NULL
|
Oracle error code generated by the action. Some useful values:
0 : the action succeeded
2004 : security violation
|
CLIENT_ID
|
VARCHAR2(64)
|
|
Client identifier in each Oracle session
|
SESSION_CPU
|
NUMBER
|
|
Amount of CPU time used by each Oracle session
|