Encrypting password using Data mover
Hi,
I was successful resetting password in the database
UPDATE PSOPRDEFN SET OPERPSWD = ‘NEWPASSWD’, ENCRYPTED = ‘0’ WHERE OPRID = ‘PS’;
When I login to Data Mover to encrypt the password
It was not encrypting message "unable to update password field' please make sure to use PTOPERPSWDV2 ....
We have PTOOLS Ver 8.56
PeopleSoft application 9.2
I also tried the password script
UPDATE PSOPRDEFN SET PTOPERPSWDV2 = OPRID, OPERPSWDSALT=' ', ENCRYPTED = 0 WHERE PTOPERPSWDV2 <> ' ';
values
UPDATE PSOPRDEFN SET PTOPERPSWDV2 = 'PS', OPERPSWDSALT='MYPASSWORD ', ENCRYPTED = 0 WHERE PTOPERPSWDV2 != ' MYPASSWORD';
Result : updated 223,000 users not only PS account so had to rollback.
Can you please let me know what is the correct way of