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(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)`	This column is obsolete and maintained for backward compatibility. The value of this column is always `-/-`
`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`