| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
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) | 
This column is obsolete and maintained for backward compatibility. The value of this column is always -/- | 
|
EXE | 
VARCHAR2(3) | 
Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL | 
|
FBK | 
VARCHAR2(3) | 
Auditing FLASHBACK WHENEVER SUCCESSFUL / UNSUCCESSFUL | 
|
REA | 
VARCHAR2(3) | 
Auditing READ WHENEVER SUCCESSFUL / UNSUCCESSFUL |