Application Express comes with three standard ways to authenticate users on applications. We can use the credentials of database users, we can use the credentials of users defined within APEX itself, or we can use the credentials defined in the Database Access Descriptor. In this recipe, we will show how to add our own Authentication Scheme to this list.
An Authentication Scheme controls access to an entire application as opposed to an Authorization Scheme that controls access to individual components inside the application.
Simply put, an Authentication Scheme is what is called when a user clicks on the Login button.
First, we need a table to store the data for our users. In our application, ...