hakk

software development, devops, and other drivel
Tree lined path

PeopleTools Update User Password DataMover

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;