Note
This view is introduced in OceanBase Database V2.2.77.
Purpose
The DBA_AUDIT_EXISTS view displays the audit trail entries generated by the AUDIT EXISTS and AUDIT NOT EXISTS statements.
Applicability
This view applies only to the Oracle-compatible mode of OceanBase Database.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OS_USERNAME | VARCHAR2(255) | NO | Not supported. The default value is NULL. |
| USERNAME | VARCHAR2(64) | NO | The name of the user whose operation is being audited. This is not the ID number. |
| USERHOST | VARCHAR2(32) | NO | Not supported. The default value is NULL. |
| TERMINAL | VARCHAR2(255) | NO | Not supported. The default value is NULL. |
| TIMESTAMP | DATE | NO | The date and time (UTC) when the audit trail entry is created in the local database session (the user login date and time in the audit session). |
| OWNER | VARCHAR2(64) | YES | The predefined creator of the object that does not exist. |
| OBJ_NAME | VARCHAR2(256) | YES | The name of the object affected by the operation. |
| ACTION_NAME | VARCHAR2(128) | NO | The name of the action corresponding to the numeric code in the action column of the DBA_AUDIT_TRAIL view. |
| NEW_OWNER | VARCHAR2(64) | YES | The owner of the object named in the NEW_NAME column. |
| NEW_NAME | VARCHAR2(256) | YES | The name of the object after it is renamed or the name of the base object. |
| OBJ_PRIVILEGE | VARCHAR2(255) | NO | The object privilege granted or revoked by the GRANT or REVOKE statement. |
| SYS_PRIVILEGE | VARCHAR2(255) | NO | The system privilege granted or revoked by the GRANT or REVOKE statement. |
| GRANTEE | VARCHAR2(128) | NO | The name of the grantor specified in the GRANT or REVOKE statement. |
| SESSIONID | NUMBER(38) | NO | For V4.3.x:
|
| ENTRYID | NUMBER(38) | NO | The ID number of each audit trail entry in the session. |
| STATEMENTID | NUMBER(38) | NO | The ID number of each statement. |
| RETURNCODE | NUMBER(38) | NO | The error code generated by the operation. |
| CLIENT_ID | VARCHAR2(40) | NO | Not supported. The default value is NULL. |
| ECONTEXT_ID | VARCHAR2(40) | NO | Not supported. The default value is NULL. |
| SESSION_CPU | NUMBER(38) | NO | The CPU time used by the session. |
| EXTENDED_TIMESTAMP | TIMESTAMP(6) WITH TIME ZONE | NO | The timestamp when the audit trail entry is created in the UTC time zone. |
| PROXY_SESSIONID | NUMBER(38) | NO | The sequence number of the proxy session. |
| GLOBAL_UID | NUMBER(38) | NO | The global user ID of the user. |
| INSTANCE_NUMBER | VARCHAR2(40) | NO | Not supported. The default value is NULL. |
| OS_PROCESS | VARCHAR2(40) | NO | Not supported. The default value is NULL. |
| TRANSACTIONID | VARCHAR2(128) | NO | The transaction ID of the transaction that accesses or modifies the object. |
| SCN | NUMBER(38) | NO | Not supported. The default value is NULL. |
| SQL_BIND | VARCHAR2(2000) | NO | Not supported. The default value is NULL. |
| SQL_TEXT | VARCHAR2(2000) | NO | The SQL text of the query. |
| OBJ_EDITION_NAME | VARCHAR2(128) | NO | Not supported. The default value is NULL. |
Sample query
Query the audit entries generated by the AUDIT EXISTS and AUDIT NOT EXISTS statements.
obclient [SYS]> SELECT USERNAME, USERHOST, TIMESTAMP, ACTION_NAME, SQL_TEXT FROM SYS.DBA_AUDIT_EXISTS;
The query result is as follows:
+----------+----------------+-----------+-------------+------------------------------------+
| USERNAME | USERHOST | TIMESTAMP | ACTION_NAME | SQL_TEXT |
+----------+----------------+-----------+-------------+------------------------------------+
| TEST2 | 100.xx.xxx.xxx | 08-APR-25 | SELECT | SELECT * FROM SYS.DBA_AUDIT_EXISTS |
| TEST2 | 100.xx.xxx.xxx | 08-APR-25 | SELECT | SELECT * FROM SYS.DBA_AUDIT_EXISTS |
| TEST2 | 100.xx.xxx.xxx | 08-APR-25 | SELECT | SELECT * FROM SYS.DBA_AUDIT_EXISTS |
+----------+----------------+-----------+-------------+------------------------------------+
3 rows in set
References
Query the audit entries for all objects:
Query the audit entries for
CONNECTandDISCONNECT:Query all audit entries:
Query the audit entries for the
GRANT,REVOKE,AUDIT,NOAUDIT, andALTER SYSTEMstatements:For more information about security audit, see the following topics: