Useful for when the main user id gets locked out. First log into Datamover in bootstrap mode. Then using the script below update the users password.
Note: the script will vary depending on the peopletools version. I forget what the version is exactly, 8.54 I believe.
For earlier versions of PeopleTools:
update PSOPRDEFN
set OPERPSWD = 'password', ENCRYPTED = 0
where OPRID = 'OPRID';
-- to encrypt the password
encrypt_password OPRID;
For later versions of PeopleTools
update PSOPRDEFN
set OPERPSWD = ' ',
PTOPERPSWD = 'password',
ENCRYPTED = 0
where OPRID = 'OPRID';
-- to encrypt the password
encrypt_password OPRID;