Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Application user access in apex

van Baal HRAug 28 2017 — edited Aug 28 2017

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
This post has been answered by van Baal HR on Aug 28 2017
Jump to Answer

Comments

Create a custom authentication process and check for the entry in your custom table for that user.

van Baal HR
Answer

That is just what I did. I have created a separate package with a function and a procedure in it, that uses the user defined table to select the user data from. Then I changed the code behind the login process to call for the newly created package. I have pretty much used the concept posed here: http://o7planning.org/en/10443/custom-authentication-in-oracle-apex#a1349999

Marked as Answer by van Baal HR · Sep 27 2020
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 25 2017
Added on Aug 28 2017
#access, #apex-discussions, #login, #user
2 comments
221 views