Reset User password Script

In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
Post Reply
admin
Posts: 1956
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Reset User password Script

Post by admin »

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;
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests