Sunday, April 10, 2016

Validating sysadmin password in 11i/R12

Use Following query to validate wether sysadmin password that we are using is correct or not

select fnd_web_sec.validate_login('SYSADMIN','')
from dual;

If it returns Y then sysadmin password is correct.
If it returns N then sysadmin password that we are using is wrong.

No comments: