Purpose
The DBA_STMT_AUDIT_OPTS view displays audit configuration details at the statement level.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
STMT_AUDIT_OPTION_MAP
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| USER_NAME | VARCHAR2(128) | NO | The username of the user whose actions were audited. |
| PROXY_NAME | VARCHAR2(128) | NO | The name of the proxy user whose actions were audited. The value is always NULL. |
| AUDIT_OPTION | VARCHAR2(128) | NO | The type ID of auditing at the statement level. |
| SUCCESS | VARCHAR2(10) | NO | The auditing mode when the statement is executed. |
| FAILURE | VARCHAR2(10) | NO | The auditing mode when the statement failed to be executed. |