Update User Password

This is a very simple Datamover script to update a user's password in PeopleSoft (PSOPRDEFN) and re-encrypt it. Useful if you can't access the PIA (e.g. during installation) but need to update user passwords.

Replace new_password with the new password and YOUR_USER_OPRID with your user's operator ID.

-- Change a user's password and re-encrypt it.
-- http://www.peoplesoftwiki.com/update-user-password
 
update PSOPRDEFN
set OPERPSWD = 'new_password', ENCRYPTED = 0 
where OPRID = 'YOUR_USER_OPRID';
 
encrypt_password YOUR_USER_OPRID;

If you do not have access to another account to run data mover script. You can use the following method described below.

Logon to a different PeopleSoft database where you can login thru PIA and run the following SQL.

SELECT operpswd
FROM   psoprdefn
WHERE  oprid = 'YOUR_USER_OPRID';

copy the operpaswd.

Logon to the database where your PIA logon is not working.

UPDATE psoprdefn
SET    operpswd = 'new_password',
       lastpswdchange = '1-jan-2099',
       acctlock = 0
WHERE  emplid = 'YOUR_USER_EMPLID'
        OR oprid = 'YOUR_USER_OPRID';

The password is reset as the same password that works in the other environment.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License