DBA_OBJ_AUDIT_OPTS

DBA_OBJ_AUDIT_OPTS describes auditing options on all objects.

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.

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(128)   Owner of the object
OBJECT_NAME VARCHAR2(128)   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
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

See Also: