DBA_OBJ_AUDIT_OPTS

Friday, July 18, 2008

Oracle 11gR1

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	NULL	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`

Spatial DBA - Oracle and ArcSDE