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 and the schema name, <database pool name>/<schema name>.

    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.