Note
This view is available starting with V2.2.30.
Purpose
Records the default audit conditions for any object. The value of each column can be one of the following:
-/-: Not audited by defaultA/-: Audited only when the statement is executed successfully-/A: Audited only when the statement is executed unsuccessfullyA/A: Audited regardless of whether the statement is executed successfully or unsuccessfullyApplicability
This view applies only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| ALT | VARCHAR2(3) | NO | ALTER operation |
| AUD | VARCHAR2(3) | NO | AUDIT operation |
| COM | VARCHAR2(3) | NO | COMMENT operation |
| DEL | VARCHAR2(3) | NO | DELETE operation |
| GRA | VARCHAR2(3) | NO | GRANT operation |
| IND | VARCHAR2(3) | NO | INDEX operation |
| INS | VARCHAR2(3) | NO | INSERT operation |
| LOC | VARCHAR2(3) | NO | LOCK operation |
| REN | VARCHAR2(3) | NO | RENAME operation |
| SEL | VARCHAR2(3) | NO | SELECT operation |
| UPD | VARCHAR2(3) | NO | UPDATE operation |
| REF | VARCHAR2(3) | NO | REFERENCE operation. This operation is defined but not supported. The default value is NULL. |
| EXE | VARCHAR2(3) | NO | EXECUTE operation |
| FBK | VARCHAR2(3) | NO | FLASHBACK operation |
| REA | VARCHAR2(3) | NO | READ operation |
Sample query
Query the audit rules that audit any object by default.
obclient [SYS]> SELECT * FROM SYS.ALL_DEF_AUDIT_OPTS;
The query result is as follows:
+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+
| ALT | AUD | COM | DEL | GRA | IND | INS | LOC | REN | SEL | UPD | REF | EXE | FBK | REA |
+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+
| -/- | -/- | -/- | A/A | -/- | -/- | A/A | -/- | -/- | -/- | A/A | -/- | -/- | -/- | -/- |
+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+
1 row in set
References
For more information about the detailed configuration of object-level auditing, see DBA_OBJ_AUDIT_OPTS.
For more information about the detailed configuration of statement-level auditing, see DBA_STMT_AUDIT_OPTS.