How to update Peoplesoft userid password in 'PSOPRDEFN' table for 8.54/8.55?


8.54:

UPDATE PSOPRDEFN SET OPERPSWD = 'password', ENCRYPTED = 0 WHERE OPRID = 'PS';

ENCRYPT_PASSWORD PS;

8.55:


UPDATE PSOPRDEFN SET PTOPERPSWDV2 = 'password', OPERPSWDSALT=' ', ENCRYPTED = 0 WHERE OPRID='PS'; 

ENCRYPT_PASSWORD *;