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 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 of this column 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. |