Search This Blog

Tuesday, July 19, 2011

Bulk Password Change Script

After running below script, system will ask you to change the password.
begin
fnd_user_pkg.updateuser(
x_user_name => '204020779'
, x_owner => 'CUST'
, x_unencrypted_password => 'change123',
x_password_date => to_date('2','J')
);
commit;
end;

After running below script, system will not ask you to change the password.

BEGIN
FND_USER_PKG.UPDATEUSER(x_user_name            => 'teamsearch'
                       ,x_owner                => 'SEED'
                       ,x_unencrypted_password => 'oracle@123'
                       ,x_password_date        => SYSDATE + 500);

END;


No comments:

Post a Comment