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

VIEW: SYS.CDB_PRIV_AUDIT_OPTS

Object Details
Object Name: CDB_PRIV_AUDIT_OPTS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Describes current system privileges being audited across the system and by user in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
USER_NAME VARCHAR2 (30)
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 (30)
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
PRIVILEGE VARCHAR2 (40) Yes 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
CON_ID NUMBER

container id
Query Text

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


SELECT USER_NAME
,      PROXY_NAME
,      PRIVILEGE
,      SUCCESS
,      FAILURE
,      CON_ID
FROM SYS.CDB_PRIV_AUDIT_OPTS;

Dependencies

[top of page]

SYS.CDB_PRIV_AUDIT_OPTS does not reference any database object

SYS.CDB_PRIV_AUDIT_OPTS is referenced by following:

SchemaPUBLIC
SynonymCDB_PRIV_AUDIT_OPTS