Purpose
The ALL_DEF_AUDIT_OPTS view displays the default object-auditing conditions for any object. Valid values of each column are:
-/-: No auditing is performed by default.S/-: Auditing is performed when the statement is executed.-/S: Auditing is performed when the statement fails to be executed.S/S: Auditing is performed regardless of whether the statement is executed.Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_OBJ_AUDIT_OPTS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| 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, which is defined but not supported at present. The default value is NULL. |
| EXE | VARCHAR2(3) | NO | The EXECUTE operation. |
| FBK | VARCHAR2(3) | NO | The FLASHBACK operation. |
| REA | VARCHAR2(3) | NO | The READ operation. |