Note
This view is available starting with V2.2.30.
Purpose
Records the detailed configuration of object-level auditing.
Applicability
This view is applicable only to OceanBase Database in Oracle-compatible mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The name of the object owner. |
| 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 column is no longer in use. |
| 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. |
Sample query
Query the detailed configuration of object-level auditing.
obclient [SYS]> SELECT * FROM SYS.DBA_OBJ_AUDIT_OPTS;
The query result is as follows:
+-------+-------------+-------------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+
| OWNER | OBJECT_NAME | OBJECT_TYPE | ALT | AUD | COM | DEL | GRA | IND | INS | LOC | REN | SEL | UPD | REF | EXE | CRE | REA | WRI | FBK |
+-------+-------------+-------------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+
| SYS | T_SUBPART | TABLE | -/- | -/- | -/- | A/A | -/- | -/- | A/A | -/- | -/- | -/- | A/A | -/- | -/- | -/- | -/- | -/- | -/- |
+-------+-------------+-------------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+
1 row in set
The query result indicates:
-/-: The operation is not audited by default.A/-: The operation is audited only when the statement is successfully executed.-/A: The operation is audited only when the statement is failed.A/A: The operation is audited regardless of whether the statement is successfully executed.
References
Query the default audit rules for all objects: ALL_DEF_AUDIT_OPTS
Query the detailed configuration of statement-level auditing: DBA_STMT_AUDIT_OPTS
For more information about how to enable auditing and set audit rules, see the following topics: