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; NULL for system-wide auditing |
|
PROXY_NAME |
VARCHAR2(30) |
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 |