Note
This view is available starting with V2.2.30.
Purpose
This view records the detailed configurations of statement-level auditing.
Applicability
This view is applicable only to OceanBase Database in Oracle mode.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| USER_NAME | VARCHAR2(128) | NO | The username of the audited user. |
| PROXY_NAME | VARCHAR2(128) | NO | The username of the audited proxy user. This column is always NULL. |
| AUDIT_OPTION | VARCHAR2(128) | NO | The type ID of statement-level auditing. |
| SUCCESS | VARCHAR2(10) | NO | The auditing mode when the statement is executed successfully. |
| FAILURE | VARCHAR2(10) | NO | The auditing mode when the statement is executed unsuccessfully. |
Sample query
Query the detailed configurations of statement-level auditing.
obclient [SYS]> SELECT * FROM SYS.DBA_STMT_AUDIT_OPTS;
The query result is as follows:
+-----------+------------+----------------+-----------+-----------+
| USER_NAME | PROXY_NAME | AUDIT_OPTION | SUCCESS | FAILURE |
+-----------+------------+----------------+-----------+-----------+
| SYS | NULL | TABLE | BY ACCESS | NOT SET |
| SYS | NULL | ALL STATEMENTS | BY ACCESS | BY ACCESS |
| NULL | NULL | SESSION | BY ACCESS | BY ACCESS |
+-----------+------------+----------------+-----------+-----------+
3 rows in set
References
Query the types, names, and priorities of statement-level auditing: STMT_AUDIT_OPTION_MAP
Query the detailed configurations of object-level auditing: DBA_OBJ_AUDIT_OPTS
Query the default auditing rules for all objects: ALL_DEF_AUDIT_OPTS
For more information about how to enable auditing and set auditing rules, see the following topics: