Hello dear APEX-experts,
we are developing a small web-portal with APEX and to grant the users access, we have created a table with user data like email address, telefone number, first name, last name and position. This table has to be used to control the acces to the application. The user table also has a column for the role, the user has. The problem I have is how to use this table as the source for the login mask. I have been looking for days already and time is slipping away.
The processing of the login mask is the following:
apex_authentication.login
( p_username => :P101_USERNAME
, p_password => :P101_PASSWORD
);
Unfortunately there is no possibility to look at the logic, that is being used here. I would like this procedure to look into the table, that we created for this purpose.
The reason why we use this concept is, that the people that use the application do not develop. They are just users, creating and granting rights to other users.
Is there anyone that can help me with this?
Thank you very much.
Hans van Baal