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 AI 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.

On the Autonomous AI Database Details page select Database Actions and from the quick actions list click SQL.
Within the SQL Worksheet, query the DBA_OPERATOR_ACCESS view.

For example:
```
SELECT * FROM DBA_OPERATOR_ACCESS;
```

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 AI Database instance. In this case, when you query the view you will not see any rows returned.

DBA_OPERATOR_ACCESS View

The DBA_OPERATOR_ACCESS view describes top level statements executed in the Autonomous AI 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`.