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

VIEW: SYS.ALL_DEF_AUDIT_OPTS

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

Auditing options for newly created objects

[View Source]

Columns
Name Datatype Length Mandatory Comments
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
FBK VARCHAR2 (3)
Auditing FLASHBACK WHENEVER SUCCESSFUL / UNSUCCESSFUL
REA VARCHAR2 (3)
Auditing READ WHENEVER SUCCESSFUL / UNSUCCESSFUL
Query Text

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


SELECT ALT
,      AUD
,      COM
,      DEL
,      GRA
,      IND
,      INS
,      LOC
,      REN
,      SEL
,      UPD
,      REF
,      EXE
,      FBK
,      REA
FROM SYS.ALL_DEF_AUDIT_OPTS;

Dependencies

[top of page]

SYS.ALL_DEF_AUDIT_OPTS references the following:

SchemaSYS
TableOBJ$
TableTAB$
SYS.ALL_DEF_AUDIT_OPTS is referenced by following:

SchemaPUBLIC
SynonymALL_DEF_AUDIT_OPTS