| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
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 |