Static Data Dictionary Views, 17 of 452

Oracle8i Reference
Release 2 (8.1.6)
Part Number A76961-01

Static Data Dictionary Views, 17 of 452

ALL_DEF_AUDIT_OPTS

ALL_DEF_AUDIT_OPTS contains default object-auditing options that will be applied when objects are created. The output for each column takes one of the following forms:

-/-: no default auditing
S/-: auditing whenever successful

-/S: auditing whenever not successful

Column Datatype NULL Description

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

VARCHAR2(3)

Auditing REFERENCES WHENEVER SUCCESSFUL / UNSUCCESSFUL (not used)

EXE

VARCHAR2(3)

Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL

Oracle

Copyright © 1996-2000, Oracle Corporation.
All Rights Reserved.