View Oracle Cloud Infrastructure Operations Actions
The
DBA_OPERATOR_ACCESS
view stores information on the actions that Oracle Cloud
Infrastructure cloud operations performs on your Autonomous Database.
These steps use Database Actions to query the
DBA_OPERATOR_ACCESS
view. You can query this view from any SQL
connection by connecting as a user with the proper privileges.
Notes for the DBA_OPERATOR_ACCESS
view:
-
You can continuously move this audit data to the object store for purposes such as integration with Security Information and Event Management (SIEM) tools. See Create and Configure a Pipeline for Export with Timestamp Column for more information on using pipelines to continuously export query results to object store.
-
The
DBA_OPERATOR_ACCESS
view provides information starting on October 4, 2022, the date this feature was introduced. The view does not provide information prior to October 4, 2022. -
The
DBA_OPERATOR_ACCESS
view may not show results if Oracle Cloud Infrastructure cloud operations hasn't performed any actions or run any statements in your Autonomous Database instance. In this case, when you query the view you will not see any rows returned.
- DBA_OPERATOR_ACCESS View
TheDBA_OPERATOR_ACCESS
view describes top level statements executed in the Autonomous Database instance by Oracle Cloud Infrastructure operations.
DBA_OPERATOR_ACCESS View
The DBA_OPERATOR_ACCESS
view describes top level statements
executed in the Autonomous Database instance by
Oracle Cloud
Infrastructure operations.
Column | Datatype | Description |
---|---|---|
SQL_TEXT |
VARCHAR2(4000) |
SQL text of the statement executed by the operator. |
EVENT_TIMESTAMP |
DATE |
Timestamp of the operator action in UTC (Coordinated Universal Time). |
REQUEST_ID |
VARCHAR2(64) |
Request number related to the reason behind the operator action. This could be a bug number, an SR number, or a change ticket request number that provides information on the reason for the action. |
REASON |
VARCHAR2(64) |
Reason for the operator action. This provides context for the reason
behind the action and may have a value such as:
MITIGATION , DIAGNOSTIC
COLLECTION , or CUSTOMER
REQUEST .
|
Parent topic: View Oracle Cloud Infrastructure Operations Actions