Note
This view is available starting with V2.2.30.
Purpose
This view records the detailed configuration of statement-level auditing.
Applicability
This view is available only in Oracle-compatible mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| USER_NAME | VARCHAR2(128) | NO | The username of the user to be audited. |
| PROXY_NAME | VARCHAR2(128) | NO | The username of the proxy user to be audited. The value of 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 execution succeeds. |
| FAILURE | VARCHAR2(10) | NO | The auditing mode when the statement execution fails. |
Sample query
Query the detailed configuration 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 configuration 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: