How to use two authentication type together - Oracle Application Express + Custom Database Authentication
This blog is about how you can use two different authentication scheme in one single custom authentication. For example, if I wanted my users to be authenticated from my custom database table, but at the same time I want few admin users - who are my application's super users (I might want to enable few extra options to them) and they are already my Application Express Users (can be a developer or administrator) and I wanted to authenticate both of them in a single authentication function. So, here I will need to achieve two things, Authenticate Function First check if the user is authenticated via APEX user's credentials. If not, the user is authenticated via My Custom authentication function. Authorization Function Check if logged in user is a valid Application Express user If not, the user is a regular database user. Following is a sample code block for authentication function: function my_multi_auth( p_username in varchar2, p_password in varchar2...
