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

VIEW: SYS.DBA_OBJ_AUDIT_OPTS

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

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128)
Owner of the object
OBJECT_NAME VARCHAR2 (128)
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
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
FROM SYS.DBA_OBJ_AUDIT_OPTS;

Dependencies

[top of page]

SYS.DBA_OBJ_AUDIT_OPTS references the following:

SchemaSYS
TableDIR$
TableEDITION$
TableJAVAOBJ$
TableLIBRARY$
TableMODEL$
TableOBJ$
TableOLAP_CUBES$
TableOLAP_CUBE_BUILD_PROCESSES$
TableOLAP_CUBE_DIMENSIONS$
TableOLAP_MEASURE_FOLDERS$
TablePROCEDURE$
TableSEQ$
TableSQLTXL$
TableTAB$
TableTYPE_MISC$
TableUSER$
TableVIEW$
View_CURRENT_EDITION_OBJ
SYS.DBA_OBJ_AUDIT_OPTS is referenced by following:

SchemaPUBLIC
SynonymDBA_OBJ_AUDIT_OPTS
SchemaSYS
ProcedureDBMS_FEATURE_AUDIT_OPTIONS - show dependent code
ViewSM$AUDIT_CONFIG