DBA_OBJ_AUDIT_OPTSAuditing options for all tables and views with atleast one option set------------------------------------------------------------------------------------OWNER VARCHAR2 Owner of the objectOBJECT_NAME VARCHAR2 Name of the objectOBJECT_TYPE VARCHAR2 Type of the objectALT VARCHAR2 Auditing ALTER WHENEVER SUCCESSFUL / UNSUCCESSFULAUD VARCHAR2 Auditing AUDIT WHENEVER SUCCESSFUL / UNSUCCESSFULCOM VARCHAR2 Auditing COMMENT WHENEVER SUCCESSFUL / UNSUCCESSFULDEL VARCHAR2 Auditing DELETE WHENEVER SUCCESSFUL / UNSUCCESSFULGRA VARCHAR2 Auditing GRANT WHENEVER SUCCESSFUL / UNSUCCESSFULIND VARCHAR2 Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFULINS VARCHAR2 Auditing INSERT WHENEVER SUCCESSFUL / UNSUCCESSFULLOC VARCHAR2 Auditing LOCK WHENEVER SUCCESSFUL / UNSUCCESSFULREN VARCHAR2 Auditing RENAME WHENEVER SUCCESSFUL / UNSUCCESSFULSEL VARCHAR2 Auditing SELECT WHENEVER SUCCESSFUL / UNSUCCESSFULUPD VARCHAR2 Auditing UPDATE WHENEVER SUCCESSFUL / UNSUCCESSFULREF CHAR Dummy REF column. Maintained for backward compatibility of the viewEXE VARCHAR2 Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFULCRE VARCHAR2 Auditing CREATE WHENEVER SUCCESSFUL / UNSUCCESSFULREA VARCHAR2 Auditing READ WHENEVER SUCCESSFUL / UNSUCCESSFULWRI VARCHAR2 Auditing WRITE WHENEVER SUCCESSFUL / UNSUCCESSFULFBK VARCHAR2 Auditing FLASHBACK WHENEVER SUCCESSFUL / UNSUCCESSFULDBA_OBJ_COLATTRSDescription of object columns and attributes contained in all tables in the database------------------------------------------------------------------------------------OWNER VARCHAR2 Owner of the tableTABLE_NAME VARCHAR2 Name of the table containing the object column or attributeCOLUMN_NAME VARCHAR2 Fully qualified name of the object column or attributeSUBSTITUTABLE VARCHAR2 Indication of whether the column is substitutable or not
