Set Up Database Account Credentials

Introduction
Setting up database account credentials in Oracle APEX allows your application to authenticate users using Oracle database accounts. This method leverages the database’s native authentication system to control access, which is useful in environments where database-level security is preferred or required. Proper configuration ensures secure and efficient user management directly through the database.

How to Set Up Database Account Credentials in Oracle APEX

1. Create Database Users

   • Use SQL*Plus or SQL Developer to create database users who will access your application.

   • Assign appropriate roles and privileges for these users to access necessary schema objects.

2. Open Your APEX Application

   • Log in to Oracle APEX and open the application where you want to use database authentication.

3. Navigate to Authentication Schemes

   • Go to Shared Components > Authentication Schemes.

4. Create a New Authentication Scheme

   • Click Create and select Database Account as the authentication type.

   • Name the scheme appropriately (e.g., DB_Account_Auth).

5. Configure the Scheme

   • Optionally configure parameters such as session timeout, login/logout pages, and error messages.

   • No additional PL/SQL code is required as APEX uses the Oracle database authentication mechanism.

6. Make the Scheme Current

   • Save the new scheme and click Make Current to activate it for the application.

7. Test the Login

   • Run the application and test login using one of the configured database user credentials.

Follow these steps to configure Database Account Credentials authentication for your application:

1. Navigate to the Workspace home page.

2. Open App Builder.

3. Select an application.

4. On the Application home page, go to Shared Components.

5. Under Security, select Authentication Schemes.

6. On the Authentication Schemes page, click Create.

7. Choose Based on a pre-configured scheme from the gallery and click Next.

8. Under Name: 

• Name: Enter a reference name for the authentication scheme.

• Scheme Type: Select Database Accounts.

9. Click Create Authentication Scheme.

This setup allows users to authenticate using their database account credentials.

Best Practices

• Ensure database users have only the minimal privileges necessary for application functions.

• Avoid using shared database accounts; assign individual user accounts whenever possible.

• Regularly review and manage database account passwords and privileges.

• Use secure password policies enforced at the database level.

• Monitor database account usage and audit failed login attempts.

Oracle APEX Documentation
For more detailed information, visit:
https://docs.oracle.com/en/database/oracle/apex/23.2/aeapp/database-authentication.html

Conclusion
Setting up database account credentials in Oracle APEX integrates application authentication directly with Oracle database users, offering a straightforward and secure way to manage access. By following best practices in user creation and privilege management, you ensure your application remains both secure and compliant with your organization’s policies.