1. App Builder User's Guide
  2. Managing Application Security
  3. Establishing User Identity Through Authentication
  4. Understanding Preconfigured Authentication Schemes
  5. Oracle APEX Accounts

20.4.3.1 Oracle APEX Accounts

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

Parent topic: Understanding Preconfigured Authentication Schemes

20.4.3.1.1 About Oracle APEX Accounts

Oracle APEX 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.

Oracle APEX 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.

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

Tip:

Oracle does not recommend Oracle APEX 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 APEX Users in Oracle APEX Administration Guide

Parent topic: Oracle APEX Accounts

20.4.3.1.2 Setting Up Oracle APEX Accounts Authentication

To set up Oracle APEX 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 Oracle APEX Accounts.
    3. Click Create Authentication Scheme.

Parent topic: Oracle APEX Accounts