Note
This view is available starting with V2.2.30.
Purpose
Records the object-level audit details configuration.
Applicability
This view applies only to OceanBase Database in Oracle mode.
Columns
| Field name | 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 field 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
View 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 shows:
-/-: By default, no auditing is performed.A/-: Auditing is performed only when the statement is executed successfully.-/A: Auditing is performed only when the statement is executed unsuccessfully.A/A: Auditing is performed regardless of whether the statement is executed successfully.
References
ALL_DEF_AUDIT_OPTS: describes the audit rules that specify to audit all objects by default.
DBA_STMT_AUDIT_OPTS: describes the detailed configuration of statement-level auditing.