Accessing Oracle Database Actions

2.2 Accessing Oracle Database Actions

Oracle Database Actions is included with Oracle REST Data Services.

To access Database Actions:

Enable SQL Developer Web in Oracle REST Data Services. For more information, see Advanced Installation Using Command-Line Prompts in Oracle REST Data Services Installation, Configuration, and Development Guide.
To use Database Actions, you must sign in as a database user whose schema has been REST-enabled.

Execute the following code as a database user with the DBA role:
```
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 that will appear in the URL the user will use to access Database Actions. Oracle recommends that you do not use the schema name itself as a security measure to keep the schema name from being exposed.
- p_auto_rest_auth specifies that the REST /metadata-catalog/ endpoint requires authorization. REST uses the metadata-catalog to get a list of published services on the schema.
In the login page (http://domain name/ords/sql-developer), enter the name of the user and click Next.

Figure 2-1 Login Page

Description of "Figure 2-1 Login Page"

You see the URL change to /ords/<Username>. Enter the password, and click Sign in. The Database Actions home page (Launchpad) appears.

When you log out, you return to the login page (http://domain name/ords/sql-developer) and are prompted for the user name again.