Oracle Database Actions
Oracle Database Actions (formerly known as SQL Developer Web) is a part of Oracle REST Data Services (ORDS), and is the web-based version of Oracle SQL Developer that enables you to connect to an Oracle database and execute queries and scripts, create database objects, build data models, and monitor database activity.
Oracle Utilities cloud services use Oracle Database Actions to connect to a cloud service database to execute read-only queries on various database schema objects.
Please refer the
Oracle REST Data Services documentation for more information about using Oracle Database Actions.
Users must be assigned to the "SQL Developer Web Online User" and "REST Enabled SQL" application roles in order to use Oracle Database Actions with Oracle Utilities cloud services. See Pre-Defined Application Roles in the Oracle Utilities Cloud Services Administration Guide for more information about application roles used with Oracle Utilities cloud services.
Access is provided to both CISREAD and STGADM database schemas to perform select/read-only queries.
• The CISREAD schema can be used to perform select and read-only queries of the production schema.
• The STGADM schema can be used to perform select and read-only queries of the staging schema (used with data migration and conversion).
• Oracle REST Data Services can access the production and staging schemas in both production and non-production environments.