Update User Password

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.

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;