Change Sysadmin Password from backend

As you very much aware that you can change SYSADMIN password using FNDCPASS utility
FNDCPASS apps/appspwd 0 Y system/manager USER SYSADMIN sysadminpwd

Here I am giving another way to change the SYSADMIN password and Application User Login passwords using fnd_user_pkg from backend. Here is the procedure

sql> declare
var_l boolean;
begin
var_l=fnd_user_pkg.change_password(’sysadmin’,’sysadminpwd’);
end;
sql> PL/SQL Procedure Successfully Compiled.
You can verify from backend that password has changed successfully or not without login to the application.

sql>select fnd_web_sec.validate_login(’sysadmin’,’sysadminpwd’) from dual;
should returns ‘Y’.

Tags: Oracle, password, pl, sql, sysadmin