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
Note: This view is deprecated and applies only to traditional auditing. Traditional auditing is desupported starting in Oracle AI Database 26ai. Though traditional auditing is desupported, any current traditional audit settings that you have will still be honored and are viewable with this view. See Oracle AI Database Security Guide for more information about how this desupport works.
| 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 |
|
EXE |
VARCHAR2(3) |
AuditingEXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL |
|
FBK |
VARCHAR2(3) |
Auditing FLASHBACK WHENEVER SUCCESSFUL / UNSUCCESSFUL |
|
REA |
VARCHAR2(3) |
Auditing READ WHENEVER SUCCESSFUL / UNSUCCESSFUL |