Purpose
The ALL_DEF_AUDIT_OPTS view displays the default object-auditing conditions for any object. Valid values of each column are as follows:
-/-: 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. |