Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
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 |
CHAR(3) |
Auditing REFERENCES WHENEVER SUCCESSFUL / UNSUCCESSFUL (not used) | |
EXE |
VARCHAR2(3) |
Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL | |
FBK |
VARCHAR2(3) |
Auditing FLASHBACK WHENEVER SUCCESSFUL / UNSUCCESSFUL |