eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_STMT_AUDIT_OPTS

Object Details

Object Name:	DBA_STMT_AUDIT_OPTS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Describes current system auditing options across the system and by user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
USER_NAME	VARCHAR2	(128)		User name if by user auditing. "ANY CLIENT" if access by a proxy on behalf of any client is being audited. NULL system wide auditing is being done
PROXY_NAME	VARCHAR2	(128)		Name of the proxy user if auditing is being done for operations being done on behalf of a client. Null if auditing is being done for operations done by the client directly
AUDIT_OPTION	VARCHAR2	(40)	Yes	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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USER_NAME
,      PROXY_NAME
,      AUDIT_OPTION
,      SUCCESS
,      FAILURE
FROM SYS.DBA_STMT_AUDIT_OPTS;

Dependencies

[top of page]

SYS.DBA_STMT_AUDIT_OPTS references the following:

SYS: AUDIT$; STMT_AUDIT_OPTION_MAP; USER$

SYS.DBA_STMT_AUDIT_OPTS is referenced by following:

PUBLIC: DBA_STMT_AUDIT_OPTS
SYS: SM$AUDIT_CONFIG