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.CDB_OBJ_AUDIT_OPTS

Object Details

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

Auditing options for all tables and views with atleast one option set in all containers

[View Source]

Columns

Name	Datatype	Length	Comments
OWNER	VARCHAR2	(30)	Owner of the object
OBJECT_NAME	VARCHAR2	(30)	Name of the object
OBJECT_TYPE	VARCHAR2	(23)	Type of the object
ALT	VARCHAR2	(3)	Auditing ALTER WHENEVER SUCCESSFUL / UNSUCCESSFUL
AUD	VARCHAR2	(3)	Auditing AUDIT WHENEVER SUCCESSFUL / UNSUCCESSFUL
COM	VARCHAR2	(3)	Auditing COMMENT WHENEVER SUCCESSFUL / UNSUCCESSFUL
DEL	VARCHAR2	(3)	Auditing DELETE WHENEVER SUCCESSFUL / UNSUCCESSFUL
GRA	VARCHAR2	(3)	Auditing GRANT WHENEVER SUCCESSFUL / UNSUCCESSFUL
IND	VARCHAR2	(3)	Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFUL
INS	VARCHAR2	(3)	Auditing INSERT WHENEVER SUCCESSFUL / UNSUCCESSFUL
LOC	VARCHAR2	(3)	Auditing LOCK WHENEVER SUCCESSFUL / UNSUCCESSFUL
REN	VARCHAR2	(3)	Auditing RENAME WHENEVER SUCCESSFUL / UNSUCCESSFUL
SEL	VARCHAR2	(3)	Auditing SELECT WHENEVER SUCCESSFUL / UNSUCCESSFUL
UPD	VARCHAR2	(3)	Auditing UPDATE WHENEVER SUCCESSFUL / UNSUCCESSFUL
REF	CHAR	(3)	Dummy REF column. Maintained for backward compatibility of the view
EXE	VARCHAR2	(3)	Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL
CRE	VARCHAR2	(3)	Auditing CREATE WHENEVER SUCCESSFUL / UNSUCCESSFUL
REA	VARCHAR2	(3)	Auditing READ WHENEVER SUCCESSFUL / UNSUCCESSFUL
WRI	VARCHAR2	(3)	Auditing WRITE WHENEVER SUCCESSFUL / UNSUCCESSFUL
FBK	VARCHAR2	(3)	Auditing FLASHBACK WHENEVER SUCCESSFUL / UNSUCCESSFUL
CON_ID	NUMBER		container id

Query Text

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


SELECT OWNER
,      OBJECT_NAME
,      OBJECT_TYPE
,      ALT
,      AUD
,      COM
,      DEL
,      GRA
,      IND
,      INS
,      LOC
,      REN
,      SEL
,      UPD
,      REF
,      EXE
,      CRE
,      REA
,      WRI
,      FBK
,      CON_ID
FROM SYS.CDB_OBJ_AUDIT_OPTS;

Dependencies

[top of page]

SYS.CDB_OBJ_AUDIT_OPTS does not reference any database object

SYS.CDB_OBJ_AUDIT_OPTS is referenced by following:

PUBLIC: CDB_OBJ_AUDIT_OPTS