2.3 Signing In to Database Actions

You can sign in to Database Actions by connecting to a single default database or to multiple databases or by using a schema alias.

Note:

• From Oracle REST Data Services, you can access the Database Actions Sign In page from the ORDS landing page (https://example.com/ords).

• From APEX, you can open Database Actions directly from the SQL workshop dropdown menu. See Accessing SQL Developer Web Directly from APEX

The Sign in page has a languages menu on the top right where you can select the language to display.

Default Database

To connect to a single default database:

• In the Database Actions Sign-in page, enter your user name and password and click Sign in.

  Note:

  In the Password field, if the CAPS LOCK key is turned on, an up arrow icon is displayed in the right corner of the field.

ORDS Schema Alias

To connect to a database using an ORDS schema alias, which is different from your user name:

• In the Database Actions Sign-in page, expand Advanced and in the Path field, enter the schema alias.

  See Enabling REST to know how to set up a schema alias.

• Enter your user name and password and click Sign in.

Multiple Databases

To connect to a database in a database pool:

• In the Database Actions Sign-in page, expand Advanced and in the Path field, enter the database pool name specified while installing Oracle REST Data Services.

  See Configuring Oracle REST Data Services for Multiple Databases in Oracle REST Data Services Installation and Configuration Guide for more information about database pools.

• Enter your user name and password and click Sign in.