Reset User password Script
Posted: Tue Jul 27, 2021 6:50 am
declare
p_user_name varchar2(50) default 'erpstuff';
v_new_password varchar2(50) default 'ERPstuff_123';
BEGIN
--select dbms_random.string('A',6) into v_new_password from dual;
fnd_user_pkg.updateuser( x_user_name => p_user_name , x_owner => NULL , x_unencrypted_password => v_new_password, x_password_date => to_date('2','J') );
commit;
end;
p_user_name varchar2(50) default 'erpstuff';
v_new_password varchar2(50) default 'ERPstuff_123';
BEGIN
--select dbms_random.string('A',6) into v_new_password from dual;
fnd_user_pkg.updateuser( x_user_name => p_user_name , x_owner => NULL , x_unencrypted_password => v_new_password, x_password_date => to_date('2','J') );
commit;
end;