Update User Password

This is a very simple Data mover 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.
-- PeopleSoft Wiki: https://www.peoplesoftwiki.com
 
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 value in OPERPSWD. Logon to the database where your PIA logon is not working and run the following SQL.

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.