DBA_OBJ_AUDIT

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	Description
`OWNER`	`VARCHAR2(30)`	Owner of the object
`OBJECT_NAME`	`VARCHAR2(30)`	Name of the object
`OBJECT_TYPE`	`VARCHAR2(9)`	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`