Purpose
DBA_OBJ_AUDIT_OPTS displays detailed auditing configurations at the object level.
Related views
ALL_DEF_AUDIT_OPTS
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| OBJECT_NAME | VARCHAR2(128) | NO | The name of the object. |
| OBJECT_TYPE | VARCHAR2(23) | NO | The type of the object. |
| ALT | VARCHAR2(3) | NO | The ALTER operation. |
| AUD | VARCHAR2(3) | NO | The AUDIT operation. |
| COM | VARCHAR2(3) | NO | The COMMENT operation. |
| DEL | VARCHAR2(3) | NO | The DELETE operation. |
| GRA | VARCHAR2(3) | NO | The GRANT operation. |
| IND | VARCHAR2(3) | NO | The INDEX operation. |
| INS | VARCHAR2(3) | NO | The INSERT operation. |
| LOC | VARCHAR2(3) | NO | The LOCK operation. |
| REN | VARCHAR2(3) | NO | The RENAME operation. |
| SEL | VARCHAR2(3) | NO | The SELECT operation. |
| UPD | VARCHAR2(3) | NO | The UPDATE operation. |
| REF | VARCHAR2(3) | NO | The REFERENCES operation. Note This field is no longer used. |
| EXE | VARCHAR2(3) | NO | The EXECUTE operation. |
| WRI | VARCHAR2(3) | NO | The WRITE operation. |
| REA | VARCHAR2(3) | NO | The READ operation. |
| FBK | VARCHAR2(3) | NO | The FLASHBACK operation. |
