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.
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.