[Home] [Help] [Dependency Information]
Object Name: | CDB_STMT_AUDIT_OPTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Describes current system auditing options across the system and by user in all containers
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 | |
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 | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT USER_NAME
, PROXY_NAME
, AUDIT_OPTION
, SUCCESS
, FAILURE
, CON_ID
FROM SYS.CDB_STMT_AUDIT_OPTS;
SYS.CDB_STMT_AUDIT_OPTS does not reference any database object
SYS.CDB_STMT_AUDIT_OPTS is referenced by following:
|
|
|