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, and monitoring features in Autonomous Database.

These are the main features of Database Actions:

  • Development features:
    • Run SQL statements and scripts in the worksheet

    • Design Data Modeler diagrams using existing objects

    • Work with REST data services

    • Work with JSON data

  • Data Tools features:

    • Data Load: Load or access data from local files, cloud storage, or from remote databases.

    • Data Insights: Discover anomalies, outliers, and hidden patters in your data.

    • Catalog: Understand data dependencies and the impact of changes.

    • Business Models: Create business models for performance and analysis.

  • Administration features:

    • Database user administration

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.

To access Database Actions you can use the Oracle Cloud Infrastructure console or the Autonomous Database Service Console.

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 the Tools tab.

  2. Under Database Actions, click Open Database Actions.

  3. On the Database Actions Sign in page, enter your Username and Password.

  4. Click Sign in.

    The Database Actions page appears.

  5. On the Database Actions page 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.

To access Database Actions from the Autonomous Database Service Console:

  1. On the Autonomous Database Details page click Service Console.
  2. Click Development.
  3. Click Database Actions (SQL Developer Web).
  4. In the Database Actions Sign in page, enter your Username and Password.
  5. Click Sign in.

    On the Database Actions page, under Development click SQL to use a SQL Worksheet.

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

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 Autonomous Database service console. The ADMIN user provides access to Database Actions (SQL Developer Web) by adding the user if the user does not already exist and then REST enabling the user and providing a URL to access Database Actions.

Use Database Actions to add a user and REST enable a schema to provide a user with access to Database Actions. If the user already exists use similar steps but just REST enable the schema.

  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 REST Enable.
    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 REST enabling user access, the ADMIN provides a user with the URL to access Database Actions, as follows:
    1. Select the Autonomous Database.
    2. On the Autonomous Database Details page click Tools tab.
    3. In the Database Actions area click Open Database Actions.
    4. This opens the Database Actions Sign in page. Copy the Sign in page URL.

      The copied URL is the same as the URL the ADMIN enters to access Database Actions. For example:

      https://dbname_id.adbregion.example.com/ords/sql-developer
  3. Provide the user with the copied 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 REST enable a user with Database Actions in an SQL worksheet. In an SQL worksheet, run the following code as the ADMIN user:

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.