Re: Login Issue with users

Posted by prabhunoule on Oct 06, 2023; 5:03am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Login-Issue-with-users-tp12084p12085.html

Please find output for below queries:

SQL>  select FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE') from dual;

 

FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')
--------------------------------------------------------------------------------
Y



1) SQL> set serveroutput on
declare
v varchar2(1);
begin
v := apps.fnd_web_sec.validate_login('GORAKSHA.PRAMOD', 'sairam.123');
dbms_output.put_line('Valid? ' || v);
dbms_output.put_line('Message : ' || apps.fnd_message.get);
end;
SQL> 2 3 4 5 6 7 8
9 /
Valid? N
Message : PASSWORD_INVALID

PL/SQL procedure successfully completed.



2) SQL> set serveroutput on
declare
v varchar2(1);
begin
v := apps.fnd_web_sec.validate_login('SYSADMIN', 'sysadmin123');
dbms_output.put_line('Valid? ' || v);
dbms_output.put_line('Message : ' || apps.fnd_message.get);
end;
SQL> 2 3 4 5 6 7 8
9 /
Valid? Y
Message :

PL/SQL procedure successfully completed.