DBA_OBJ_AUDIT_OPTS describes auditing options on all objects.
USER_OBJ_AUDIT_OPTS describes auditing options on all objects owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
Owner of the object | |
OBJECT_NAME |
VARCHAR2(30) |
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) |
Auditing REFERENCE WHENEVER SUCCESSFUL / UNSUCCESSFUL (not used) |
|
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 |