Purpose
The DBA_OBJ_AUDIT_OPTS view displays detailed auditing configurations at the object level.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
ALL_DEF_AUDIT_OPTS
Columns
| Column | 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 REFERENCE operation. Note This column 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. |