DBA_OBJ_AUDIT_OPTS

DBA_OBJ_AUDIT_OPTS describes auditing options on all objects.

Related View

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