Feature
DBA_STMT_AUDIT_OPTS records detailed auditing configuration 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
Fields
| Field | 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 field 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. |