Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to change the error message Invalid login credentials if not on user table

sect55Oct 12 2018 — edited Oct 12 2018

Hi Gurus,

Oracle 11g Rel 2

APEX 5.1

I would like the system to sent two different messages:

1. If the LDAP login fails, send Invalid Logon credentials.

2. IF the LDAP logon pass, but the user is not on the Oracle User table for the application, send "You are not an authorized" user message.

Couldn't both tests are in my authentication scheme, but both returns false and get (of course) the same message. The user might think that he put the wrong password so it is a confusing message.

Can someone help me? I searched the forum and could not find a solution.

I was able to do it by doing the following:

If the user is not on the user table, I set the following before returning false:

              apex_util.set_authentication_result(p_code => 1);

              apex_util.set_custom_auth_status(p_status => 'You are not an authorized user.');

But I get the message "Please wait xx seconds to login again.

Robert

This post has been answered by Pierre Yotti on Oct 12 2018
Jump to Answer
Comments
Post Details
Added on Oct 12 2018
3 comments
5,789 views