Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_OBJ_AUDIT_OPTS

Auditing options for all tables and views

Columns
   ___________________________
 
   OWNER
      Owner of the object
   OBJECT_NAME
      Name of the object
   OBJECT_TYPE
      Type of the object
   ALT
      Auditing ALTER WHENEVER SUCCESSFUL / UNSUCCESSFUL
   AUD
      Auditing AUDIT WHENEVER SUCCESSFUL / UNSUCCESSFUL
   COM
      Auditing COMMENT WHENEVER SUCCESSFUL / UNSUCCESSFUL
   DEL
      Auditing DELETE WHENEVER SUCCESSFUL / UNSUCCESSFUL
   GRA
      Auditing GRANT WHENEVER SUCCESSFUL / UNSUCCESSFUL
   IND
      Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFUL
   INS
      Auditing INSERT WHENEVER SUCCESSFUL / UNSUCCESSFUL
   LOC
      Auditing LOCK WHENEVER SUCCESSFUL / UNSUCCESSFUL
   REN
      Auditing RENAME WHENEVER SUCCESSFUL / UNSUCCESSFUL
   SEL
      Auditing SELECT WHENEVER SUCCESSFUL / UNSUCCESSFUL
   UPD
      Auditing UPDATE WHENEVER SUCCESSFUL / UNSUCCESSFUL
   REF
      Auditing REFERENCES WHENEVER SUCCESSFUL / UNSUCCESSFUL (not used)
   EXE
      Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL
   CRE
      --
   REA
      --
   WRI
      --

Related:



Simon Sheppard
SS64.com