HOW TO View the Authentication Scheme Associated with an Application in Oracle APEX

Introduction

In Oracle APEX, the authentication scheme determines how users log in to your application. Whether you're using APEX Accounts, LDAP, or SSO, it's important to know which authentication scheme is active. Viewing the current authentication scheme helps you confirm your security configuration, especially when moving between development and production environments or troubleshooting login issues.

How to View the Authentication Scheme Associated with an Application in Oracle APEX

1. Open Your Application

   • Log in to Oracle APEX

   • From the App Builder, open the application you want to inspect

2. Navigate to Authentication Schemes

   • In the left menu, click Shared Components

   • Under the Security section, click Authentication Schemes

   • You will see a list of all authentication schemes available in the application

3. Identify the Current Scheme

   • Look for the scheme that is marked as (Current)

   • This is the active authentication method being used for the application

   • You can click on the scheme name to view details like the scheme type (e.g., APEX, LDAP, Social Sign-In) and any custom PL/SQL logic or settings applied

4. Check Settings and Behavior

   • Inside the selected scheme, review configuration options such as:

     • Scheme Type (Preconfigured, Custom, Social Sign-In, etc.)

     • Username and Password validation logic

     • Post-Login and Post-Logout Redirects

   • Understanding these settings helps you maintain consistent authentication behavior across environments

In Oracle APEX, each application has an authentication scheme that controls how users log in. You can easily view the authentication scheme associated with an application through the Shared Components section.

Steps to View the Authentication Scheme

1. Access the App Builder

• Log in to your Oracle APEX workspace.

• Click on App Builder to view your applications.

2. Select the Application

• Click on the application you want to inspect.

• This will take you to the application's home page.

3. Navigate to Authentication Schemes

• Click on Shared Components under the application menu.

• Under the Security section, click Authentication Schemes.

4. View the Current Authentication Scheme

• The Authentication Schemes page displays a list of authentication schemes available for the application.

• The scheme marked as Current is the one currently in use.

5. Review Authentication Scheme Details

• Click on the current authentication scheme to open its details.

• Here, you can see its type (e.g., APEX Accounts, LDAP, Social Sign-In) and its configuration settings.

By following these steps, you can quickly check which authentication method is securing your Oracle APEX application.

Best Practices

• Regularly review the active authentication scheme before releasing updates

• Use clear naming conventions for custom authentication schemes

• Keep authentication configuration consistent between development, test, and production

• Document which scheme is used for each app to support easier maintenance

• For security reasons, avoid unnecessary changes to authentication settings in a live environment

Oracle APEX Documentation
To learn more about authentication schemes, visit the official documentation:
https://docs.oracle.com/en/database/oracle/apex/23.2/aeapp/viewing-authentication-schemes.html

Conclusion
Knowing how to view the authentication scheme associated with an Oracle APEX application is essential for managing security and ensuring proper login behavior. By quickly locating and reviewing the current authentication setup, you can confirm your app is using the correct method and maintain a secure user access strategy. Whether for development, testing, or production, keeping your authentication configuration in check helps prevent unauthorized access and supports a better user experience.