../E40402-16.epub /> ../E40402-16.mobi />

DBA_STMT_AUDIT_OPTS

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