20.4.3.1 Application Express Accounts

Application Express Accounts are user accounts that are created within and managed in the Oracle Application Express user repository. When you use this method, your application is authenticated against these accounts.

• About Application Express Accounts
  
• Setting Up Application Express Accounts Authentication
  

20.4.3.1.1 About Application Express Accounts

Application Express Accounts authentication requires that a database user (schema) exists in the local database. When using this method, the user name and password of the database account is used to authenticate the user.

Application Express Accounts is a good solution when:

• You want control of the user account repository.

• User name and password-based approach to security is sufficient.

• You do not need to integrate into a single sign-on framework.

Application Express Accounts is an especially good approach when you must get a group of users up and running on a new application quickly.

Recommendations for Production Environments

Oracle does not recommend Application Express Accounts authentication in production environments. The credentials used to log in to an application may be the same as the credentials used to log in to a workspace. In production environments, Oracle recommends using another identity provider such as Oracle Access Manager (OAM), Oracle Identity Cloud Service (IDCS), Okta, or Microsoft Azure authentication.

See Also:

"Managing Application Express Users" in Oracle Application Express Administration Guide

20.4.3.1.2 Setting Up Application Express Accounts Authentication

To set up Application Express Accounts:

1. On the Workspace home page, click the App Builder icon.
2. Select an application.
3. On the Application home page, click Shared Components.

   The Shared Components page appears.

4. Under Security, select Authentication Schemes.
5. On the Authentication Schemes page, click Create.
6. Select Based on a pre-configured scheme from the gallery and click Next.
7. Under Name:
   1. Name - Enter the name used to reference the authentication scheme by other application developers.
   2. Scheme Type - Select Application Express Accounts.
   3. Click Create Authentication Scheme.