Feature
USER_AUDIT_TRAIL describes standard audit trail entries related to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_AUDIT_TRAIL
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| OS_USERNAME | VARCHAR2(255) | NO | The username of the user whose actions were audited. This username is used for operating system (OS) logon. At present, this field is not supported and is NULL by default. |
| USERNAME | VARCHAR2(64) | NO | The username of the user whose actions were audited. |
| USERHOST | VARCHAR2(32) | NO | The name of the client host. At present, this field is not supported and is NULL by default. |
| TERMINAL | VARCHAR2(255) | NO | The identifier of the user terminal. At present, this field is not supported and is NULL by default. |
| TIMESTAMP | DATE | NO | The date and time when the audit trail entry was created in the time zone of the local database session. |
| OWNER | VARCHAR2(64) | YES | The creator of the object that was affected by the action. |
| OBJ_NAME | VARCHAR2(256) | YES | The name of the object that was affected by the action. |
| ACTION | NUMBER(38) | NO | The numeric action type code. |
| ACTION_NAME | VARCHAR2(128) | NO | The name of the action type corresponding to the numeric code in the ACTION column. |
| NEW_OWNER | VARCHAR2(64) | YES | The owner of the object named in the NEW_NAME column. |
| NEW_NAME | VARCHAR2(256) | YES | The new name of an object after a RENAME action or the name of the underlying object. |
| OBJ_PRIVILEGE | VARCHAR2(255) | NO | The object privileges granted or revoked by a GRANT or REVOKE statement. |
| SYS_PRIVILEGE | VARCHAR2(255) | NO | The system privileges granted or revoked by a GRANT or REVOKE statement. |
| ADMIN_OPTION | VARCHAR2(1) | NO | Indicates whether the role or system privilege was granted by using the ADMIN option. |
| GRANTEE | VARCHAR2(128) | NO | The name of the grantee specified in a GRANT or REVOKE statement. |
| AUDIT_OPTION | VARCHAR2(40) | NO | The auditing option set with the AUDIT statement. |
| SES_ACTIONS | VARCHAR2(19) | NO | The session summary. This field is not supported by OceanBase and is NULL by default. |
| LOGOFF_TIME | DATE | NO | The date and time when the user was logged off. |
| LOGOFF_LREAD | NUMBER(38) | NO | The logical reads for the session. |
| LOGOFF_PREAD | NUMBER | NO | The physical reads for the session. At present, this field is not supported and is NULL by default. |
| LOGOFF_LWRITE | NUMBER | NO | The logical writes for the session. At present, this field is not supported and is NULL by default. |
| LOGOFF_DLOCK | VARCHAR2(40) | NO | Indicates whether deadlocks are detected during the session. At present, this field is not supported and is NULL by default. |
| COMMENT_TEXT | VARCHAR2(65536) | YES | The text comment on the audit trail entry, which provides more information about the statement that was audited. |
| SESSIONID | NUMBER(38) | NO | The numeric ID of the session. |
| ENTRYID | NUMBER(38) | NO | The numeric ID for each audit trail entry in the session. |
| STATEMENTID | NUMBER(38) | NO | The numeric ID for each statement. |
| RETURNCODE | NUMBER(38) | NO | The error code generated by the action. |
| PRIV_USED | VARCHAR2(40) | NO | The system privilege used to execute the action. At present, this field is not supported and is NULL by default. |
| CLIENT_ID | VARCHAR2(40) | NO | The client identifier in the session. At present, this field is not supported and is NULL by default. |
| ECONTEXT_ID | VARCHAR2(40) | NO | The identifier of the application execution context. At present, this field is not supported and is NULL by default. |
| SESSION_CPU | NUMBER(38) | NO | The amount of CPU time used by the session. |
| EXTENDED_TIMESTAMP | TIMESTAMP(6) WITH TIME ZONE | NO | The timestamp of the audit trail entry when it was created in the Coordinated Universal Time (UTC) time zone. |
| PROXY_SESSIONID | NUMBER(38) | NO | The serial number of the proxy session. |
| GLOBAL_UID | NUMBER(38) | NO | The global user identifier (UID) of the user. |
| INSTANCE_NUMBER | VARCHAR2(40) | NO | The instance number specified by the INSTANCE_NUMBER initialization parameter. At present, this field is not supported and is NULL by default. |
| OS_PROCESS | VARCHAR2(40) | NO | The OS process identifier of the process. At present, this field is not supported and is NULL by default. |
| TRANSACTIONID | VARCHAR2(128) | NO | The identifier of the transaction in which the object is accessed or modified. |
| SCN | NUMBER(38) | NO | The system change number (SCN) of the query. At present, this field is not supported and is 0 by default. |
| SQL_BIND | VARCHAR2(2000) | YES | The bind variable data of the query. At present, this field is not supported and is NULL by default. |
| SQL_TEXT | VARCHAR2(2000) | YES | The SQL text of the query. |
| OBJ_EDITION_NAME | VARCHAR2(128) | NO | The name of the edition that contains the audited object. At present, this field is not supported and is NULL by default. |
| DBID | NUMBER(38) | NO | The identifier of the database that is audited. |