Connect with Built-in SQL Developer Web
You can access SQL Developer Web, a browser-based interface of Oracle SQL Developer, from Autonomous Database. On Autonomous Database SQL Developer Web is named Database Actions. You can run SQL statements and scripts in a worksheet and perform other tasks on your database with SQL Developer Web/Database Actions.
About SQL Developer Web (Database Actions)
Oracle SQL Developer Web in Autonomous Database provides a development environment and a data modeler interface for Autonomous Database.
SQL Developer Web, also known as Oracle Database Actions, is a browser-based interface for Oracle SQL Developer. It provides a subset of the features of the desktop version. See About Oracle SQL Developer Web in Using Oracle Database Actions for more information.
These are the main features of SQL Developer Web:
-
Run SQL statements and scripts in the worksheet
-
Export data
-
Design Data Modeler diagrams using existing objects
Access SQL Developer Web as ADMIN
SQL Developer Web is bundled with each Autonomous Database instance.
Oracle SQL Developer Web runs in Oracle REST Data Services and access is provided through schema-based authentication. To use Oracle SQL Developer Web, you must sign in as a database user whose schema is enabled for SQL Developer Web. By default the ADMIN user is enabled to access SQL Developer Web.
See Provide SQL Developer Web Access to Database Users to enable another database user's schema to access SQL Developer Web.
To access SQL Developer Web 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 Oracle SQL Developer Web from clients in the same Virtual Cloud Network (VCN).See Configuring Network Access with Private Endpoints for more information.
To access SQL Developer Web from the Oracle Cloud Infrastructure Console:
-
On the Autonomous Database Details page click the Tools tab.
-
In the SQL Developer Web area, click Open SQL Developer Web.
-
In the SQL Developer Web Sign in page, enter your Username and Password.
-
Click Sign in.
This shows the Oracle Database Actions 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 SQL Developer Web from the Autonomous Database Service Console:
Provide SQL Developer Web Access to Database Users
The ADMIN user can provide access to SQL Developer Web 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 SQL Developer Web (Database Actions) by REST enabling the user and providing a URL to the user to access SQL Developer Web (Database Actions).
See Create Users on Autonomous Database for information on adding database users.
Note:
As an alternative to these steps, The ADMIN user can use Database Actions User Management to REST enable a user and copy the URL.See Manage Users and User Roles on Autonomous Database - Connecting with SQL Developer Web for more information.
To REST enable a schema to provide access to SQL Developer Web:
To access SQL Developer Web a user pastes the URL into their browser and then enters the schema's Username and Password in the Sign-in dialog.