DBA_STMT_AUDIT_OPTS describes current system auditing options across the system and by user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
USER_NAME |
VARCHAR2(30) |
User name if by user auditing. ANY CLIENT if access by a proxy on behalf of a client is being audited.
|
|
PROXY_NAME |
VARCHAR2(30) |
The name of the proxy user which is performing an operation for the client. NULL if the client is performing the operation directly. |
|
AUDIT_OPTION |
VARCHAR2(40) |
NOT NULL |
Name of the system auditing option |
SUCCESS |
VARCHAR2(10) |
Mode for WHENEVER SUCCESSFUL system auditing |
|
FAILURE |
VARCHAR2(10) |
Mode for WHENEVER NOT SUCCESSFUL system auditing |