Note
This view is available starting with V2.2.30.
Purpose
This view records the detailed configurations of object-level auditing.
Applicability
This view is applicable only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| OBJECT_NAME | VARCHAR2(128) | NO | The name of the object. |
| OBJECT_TYPE | VARCHAR2(23) | NO | The type of the object. |
| ALT | VARCHAR2(3) | NO | Indicates whether the ALTER operation is audited. |
| AUD | VARCHAR2(3) | NO | Indicates whether the AUDIT operation is audited. |
| COM | VARCHAR2(3) | NO | Indicates whether the COMMENT operation is audited. |
| DEL | VARCHAR2(3) | NO | Indicates whether the DELETE operation is audited. |
| GRA | VARCHAR2(3) | NO | Indicates whether the GRANT operation is audited. |
| IND | VARCHAR2(3) | NO | Indicates whether the INDEX operation is audited. |
| INS | VARCHAR2(3) | NO | Indicates whether the INSERT operation is audited. |
| LOC | VARCHAR2(3) | NO | Indicates whether the LOCK operation is audited. |
| REN | VARCHAR2(3) | NO | Indicates whether the RENAME operation is audited. |
| SEL | VARCHAR2(3) | NO | Indicates whether the SELECT operation is audited. |
| UPD | VARCHAR2(3) | NO | Indicates whether the UPDATE operation is audited. |
| REF | VARCHAR2(3) | NO | Indicates whether the REFERENCES operation is audited. Notice This column is no longer in use. |
| EXE | VARCHAR2(3) | NO | Indicates whether the EXECUTE operation is audited. |
| WRI | VARCHAR2(3) | NO | Indicates whether the WRITE operation is audited. |
| REA | VARCHAR2(3) | NO | Indicates whether the READ operation is audited. |
| FBK | VARCHAR2(3) | NO | Indicates whether the FLASHBACK operation is audited. |
Sample query
Query the detailed configurations 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
In the query result:
-/-: The operation is not audited by default.A/-: The operation is audited only when the statement is executed successfully.-/A: The operation is audited only when the statement is executed unsuccessfully.A/A: The operation is audited regardless of whether the statement is executed successfully or unsuccessfully.
References
Query the default audit rules for all objects: ALL_DEF_AUDIT_OPTS
Query the detailed configurations of statement-level auditing: DBA_STMT_AUDIT_OPTS
For more information about how to enable auditing and set audit rules, see the following topics: