DBA_AUDIT_TRAIL
displays all audit trail entries.
USER_AUDIT_TRAIL
displays all audit trail entries related to the current user.
Column | Datatype | NULL | Description |
---|---|---|---|
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) |
Client host machine name | |
TERMINAL |
VARCHAR2(255) |
Identifier of the user's terminal | |
TIMESTAMP |
DATE |
Date and time of the creation of the audit trail entry (date and time of user login for entries created by AUDIT SESSION ) in the local database session time zone |
|
OWNER |
VARCHAR2(30) |
Creator of the object affected by the action | |
OBJ_NAME |
VARCHAR2(128) |
Name of the object affected by the action | |
ACTION |
NUMBER |
NOT NULL |
Numeric action type code. The corresponding name of the action type is in the ACTION_NAME column. |
ACTION_NAME |
VARCHAR2(28) |
Name of the action type corresponding to the numeric code in the ACTION column |
|
NEW_OWNER |
VARCHAR2(30) |
Owner of the object named in the NEW_NAME column |
|
NEW_NAME |
VARCHAR2(128) |
New name of the 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 |
|
ADMIN_OPTION |
VARCHAR2(1) |
Indicates whether the role or system privilege was granted with the ADMIN option |
|
GRANTEE |
VARCHAR2(30) |
Name of the grantee specified in a GRANT or REVOKE statement |
|
AUDIT_OPTION |
VARCHAR2(40) |
Auditing option set with the AUDIT statement |
|
SES_ACTIONS |
VARCHAR2(19) |
Session summary (a string of 16 characters, one for each action type in the order ALTER , AUDIT , COMMENT , DELETE , GRANT , INDEX , INSERT , LOCK , RENAME , SELECT , UPDATE , REFERENCES , and EXECUTE . Positions 14, 15, and 16 are reserved for future use. The characters are:
|
|
LOGOFF_TIME |
DATE |
Date and time of user log off | |
LOGOFF_LREAD |
NUMBER |
Logical reads for the session | |
LOGOFF_PREAD |
NUMBER |
Physical reads for the session | |
LOGOFF_LWRITE |
NUMBER |
Logical writes for the session | |
LOGOFF_DLOCK |
VARCHAR2(40) |
Deadlocks detected during the session | |
COMMENT_TEXT |
VARCHAR2(4000) |
Text comment on the audit trail entry, providing more information about the statement audited
Also indicates how the user was authenticated. The method can be one of the following:
|
|
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:
|
PRIV_USED |
VARCHAR2(40) |
System privilege used to execute the action | |
CLIENT_ID |
VARCHAR2(64) |
Client identifier in each Oracle session | |
ECONTEXT_ID |
VARCHAR2(64) |
Application execution context identifier | |
SESSION_CPU |
NUMBER |
Amount of CPU time used by each Oracle session | |
EXTENDED_TIMESTAMP |
TIMESTAMP(6) WITH TIME ZONE |
Timestamp of the creation of the audit trail entry (timestamp of user login for entries created by AUDIT SESSION ) in UTC (Coordinated Universal Time) time zone |
|
PROXY_SESSIONID |
NUMBER |
Proxy session serial number, if an enterprise user has logged in through the proxy mechanism | |
GLOBAL_UID |
VARCHAR2(32) |
Global user identifier for the user, if the user has logged in as an enterprise user | |
INSTANCE_NUMBER |
NUMBER |
Instance number as specified by the INSTANCE_NUMBER initialization parameter |
|
OS_PROCESS |
VARCHAR2(16) |
Operating System process identifier of the Oracle process | |
TRANSACTIONID |
RAW(8) |
Transaction identifier of the transaction in which the object is accessed or modified | |
SCN |
NUMBER |
System change number (SCN) of the query | |
SQL_BIND |
NVARCHAR2(2000) |
Bind variable data of the query | |
SQL_TEXT |
NVARCHAR2(2000) |
SQL text of the query |
Note:
TheSQL_BIND
and SQL_TEXT
columns are only populated if the AUDIT_TRAIL
initialization parameter is set to db,extended
.See Also:
"AUDIT_TRAIL"