Purpose
DBA_STMT_AUDIT_OPTS displays detailed auditing configuration at the statement level.
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 fixed to 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. |