Table: DBA_OBJ_AUDIT_OPTS
Auditing options for all tables and views
| Column Name | Description |
|---|---|
| ALT | Auditing ALTER WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| AUD | Auditing AUDIT WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| COM | Auditing COMMENT WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| CRE | |
| DEL | Auditing DELETE WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| EXE | Auditing EXECUTE 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 |
| OBJECT_NAME | Name of the object |
| OBJECT_TYPE | Type of the object |
| OWNER | Owner of the object |
| REA | |
| REF | Auditing REFERENCES WHENEVER SUCCESSFUL / UNSUCCESSFUL (not used) |
| REN | Auditing RENAME WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| SEL | Auditing SELECT WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| UPD | Auditing UPDATE WHENEVER SUCCESSFUL / UNSUCCESSFUL |
| WRI |