Connect with Built-in Oracle Database Actions

You can access Database Actions from Autonomous Database. Database Actions provides development tools, data tools, administration, and monitoring features for Autonomous Database. Using Database Actions you can run SQL statements, queries, and scripts in a worksheet.

About Database Actions (SQL Developer Web)

Database Actions provides a web-based interface with development, data tools, administration, monitoring, and download features for Autonomous Database.

These are the main features of Database Actions:

  • Development features: SQL, Data Modeler, REST, JSON, Charts, Scheduling, Oracle Machine Learning, and Oracle APEX
  • Data Tools features: Data Pump, Data Load, Catalog, Data Insights, Data Transforms, Data Analysis

  • Administration features: Database Users, APEX Workspaces, Download Client Credentials, Set Resource Management Rules

  • Monitoring features: Performance Hub and Database Monitor

  • Downloads and Related Services: Download Oracle Instant Client, Download SODA Drivers, Access Restful Data Services (ORDS) and SODA, Access Oracle Machine Learning Restful Services

See About Database Actions in Using Oracle Database Actions for more information.

Access Database Actions as ADMIN

Database Actions (also known as SQL Developer Web) is bundled with each Autonomous Database instance.

Database Actions runs in Oracle REST Data Services and access is provided through schema-based authentication. To use Database Actions, you must sign in as a database user whose schema is enabled for Database Actions. By default the ADMIN user is enabled to access Database Actions.

See Provide Database Actions Access to Database Users to enable another database user's schema to access Database Actions.

Note:

If your Autonomous Database is configured to use a Private Endpoint, then you can only access Database Actions from clients in the same Virtual Cloud Network (VCN).

See Configuring Network Access with Private Endpoints for more information.

To access Database Actions from the Oracle Cloud Infrastructure Console:

  1. On the Autonomous Database Details page click Database Actions.
  2. On the Database Actions Launchpad, select a card.

    For example, click SQL to use a SQL Worksheet. On the SQL Worksheet you can use the Consumer Group drop-down list to select the consumer group to run your SQL or PL/SQL code. See Executing SQL Statements in the Worksheet Editor for more information.

Provide Database Actions Access to Database Users

The ADMIN user can provide access to Database Actions to other database users.

Database users who are not service administrators do not have access to the Oracle Cloud Infrastructure Console. The ADMIN user provides access to Database Actions as follows:

  • Use Database Actions to add a new user, if the user does not already exist and enable Web Access for the user. If the user already exists use similar steps but just enable Web Access for the schema.

  • Provide the user with a URL to access Database Actions.

  1. As the ADMIN user, access Database Actions and create a user with the required privileges.
    1. In Database Actions, click navigation icon to show the available actions.
    2. In Database Actions, under Administration select Database Users.
    3. If the user you are adding does not already exist, click Create User.
    4. In the Create User area, on the User tab enter User Name and a Password and confirm the password.
    5. Select Web Access.
    6. In the Create User area, select Granted Roles tab and grant the appropriate roles to the user.
    7. Click Create User.
  2. After adding a user and enabling Web Access, the ADMIN provides a user with the URL to access Database Actions, as follows:

    You have two options to supply the Database Actions URL to a user:

    • Supply the Wallet file to the user and inform the user that the Wallet README file includes the Database Actions URL. See Download Client Credentials (Wallets) for more information.

    • Copy the URL and provide it to the user with the following steps:

    1. Select the Autonomous Database.
    2. On the Autonomous Database Details page click Database Actions button.
    3. Copy the URL and replace everything after /ords/ with sql-developer.

      For example:

      https://dbname_id.adbregion.example.com/ords/sql-developer
  3. Provide the user with this URL.

To access Database Actions a user pastes the URL into their browser and then enters their Username and Password in the Sign-in dialog.

As an alternative, the ADMIN can provide Web Access for a user, REST enable a user, with SQL commands. As the ADMIN user run the following code:

BEGIN
   ORDS_ADMIN.ENABLE_SCHEMA(
     p_enabled => TRUE,
     p_schema => 'schema-name',
     p_url_mapping_type => 'BASE_PATH',
     p_url_mapping_pattern => 'schema-alias',
     p_auto_rest_auth => TRUE
   );
   COMMIT;
END;
/

where:

  • schema-name is the database schema name in all-uppercase.
  • schema-alias is an alias for the schema name to use in the URL to access Database Actions.
  • p_auto_rest_auth specifies the REST /metadata-catalog/ endpoint requires authorization. REST uses the metadata-catalog to get a list of published services on the schema. Set this parameter to TRUE.

Access Database Actions, Oracle APEX, Oracle REST Data Services, and Developer Tools Using a Vanity URL

By default you access Oracle APEX apps, REST endpoints, and developer tools on Autonomous Database using the oraclecloudapps.com domain name. You can optionally configure a vanity URL or custom domain name that is easy to remember to help promote your brand identity.

After you acquire a desired domain name and matching SSL certificate from a vendor of your choice, deploy an Oracle Cloud Infrastructure Load Balancer in your Virtual Cloud Network (VCN) using your Autonomous Database as the backend. Your Autonomous Database instance must be configured with a private endpoint in the same VCN. See Configuring Network Access with Private Endpoints for more information.

To learn more, see the following: