Oracle APEX - How to change Default Authentication Schemes to Custom Authentication Schemes

In this post, I can explain how to change Default Authentication Schemes  to Custom Authentication Schemes in Oracle APEX.

- Database Level

Step 1: Create Table

Step 2: Insert Script

Step 3: Create Function to validate User

- APEX Application Level

Step 1:

- Go to Shared Components 

Step 2:

- Go to Security → Authentication Schemes

Step 3:

- Select Application Express Authentication - Current

Step 4:

- Change Scheme Type From Application Express Account to Custom

- Call Function name in the Authentication Function Name Text box

- Click Apply Changes button

Step 5:

- Run the Application

Step 6:

- Login using default Username and Password.  It return Invalid Login Credentials

- Login using credentials from apex_custom_auth table such as USER1/USER1 username and password respectively.

Video Link:

Youtube video Tutorial

Note:

If you need Table script, Insert script of data and Function description.  Please Mail me or Whatsapp me. Follow and Comment.

Email : oraclehuntltg@gmail.com

Whatsapp: 9944809554

Thanks & Regards

R. Kalaiyarasan

+91 9944809554