Sunday, May 11, 2008

Change Sysadmin Password from backend

Hi Folks,
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'.

Happy Reading
Thanks
--Guru

1 comment:

Anonymous said...

very good post... its a great thing to be able to do stuff from backend, login into forms to verify is not always feasible...