Friday, July 18, 2008

DBA_PRIV_AUDIT_OPTS

Oracle 11gR1

DBA_PRIV_AUDIT_OPTS describes current system privileges being audited 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)


The name of the proxy user which is performing an operation for the client; NULL if the client is performing the operation directly.

PRIVILEGE

VARCHAR2(40)

NOT NULL

Name of the system privilege being audited

SUCCESS

VARCHAR2(10)


Mode for WHENEVER SUCCESSFUL system auditing

FAILURE

VARCHAR2(10)


Mode for WHENEVER NOT SUCCESSFUL system auditing

Oracle data dictionary views

No comments:

Post a Comment