Update user password in PSOPRDEFN

This is a very simple Datamover script to update a user's password in PeopleSoft (PSOPRDEFN) and re-encrypt it.

update psoprdefn set operpswd = 'password', encrypted=0 where oprid ='user_oprid';

encrypt_password user_oprid;

To update password for all users,

update psoprdefn set operpswd = 'password', encrypted=0;

encrypt_password *;