Connect with Built-In Oracle Database Actions

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

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 JSON Database is configured to use a Private Endpoint, then you can only access Database Actions from clients in the same Virtual Cloud Network (VCN).

To access Database Actions from the Oracle Cloud Infrastructure Console:

1. On the Autonomous Database Details page click the Database actions dropdown list.
2. Select a quick link to go directly to a quick link action or select View all database actions to access the full Database Actions Launchpad.

   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.

Depending on your browser, if the Console cannot access the database as ADMIN you will be prompted for your database ADMIN username and password.

Description of the illustration adb_database_actions_signin.png

Provide Database Actions Access to Database Users

The ADMIN user provides access to Database Actions for 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 create a user and assign roles to the user. If the user already exists, check that Web Access is selected for the schema (with Web Access selected, the user's card shows REST Enabled).

  See Create Users on Autonomous Database for information on adding database users.

  See Required Roles to Access Tools from Database Actions for information on required roles for Database Actions.

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

After adding a user and selecting Web Access, the ADMIN provides a user with the URL to access Database Actions:

1. In Database Actions, click to show the available actions.
2. Under Administration select Database Users.

   This displays information about users, such as user names, whether a user is REST Enabled, and the last login date and time. On a user's card, the icon on the left displays the user status with one of the following colors: green (Open), blue (Locked), or red (Expired).

   The default view is Card View. You can select either grid view or card view by clicking the Card View or Grid View icons.

3. A URL is displayed in the user's card only if the user is REST Enabled. It provides the URL to access Database Actions. Click to copy the URL to the clipboard.

   
   Description of the illustration adb_database_actions_user_access.png

4. Provide the user with the URL you copied.

After you provide the URL to a user, to access Database Actions the user pastes the URL into their browser and then enters their Username and Password in the Sign-in dialog.

See Manage Users and User Roles on Autonomous Database - Connecting with Database Actions for more information.