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:
very good post... its a great thing to be able to do stuff from backend, login into forms to verify is not always feasible...
Post a Comment