Reset Password from back end

By Chris Malek | Wed, Oct 13, 2010

Here is a DMS script that needs to be run in “bootstrap” mode (sa orsysadmin user) where you can reset a PeopleTools user password from the back end.

set log c:\temp\dm.log;

update psoprdefn 
set OPERPSWD = 'KeepMeSecret', 
ENCRYPTED = 0 
where OPRID = 'VP1';


encrypt_password VP1;
Article Categories
Author Info
Chris Malek

Chris Malek is a PeopleTools® Technical Consultant with two decades of experience working on PeopleSoft enterprise software projects. He is available for consulting engagements.

About Chris Work with Chris
Looking for pain-free PeopleSoft web services? 😀
PeopleSoft Simple Web Services (SWS)

Introducing a small but powerful PeopleSoft bolt-on that makes web services very easy. If you have a SQL statement, you can turn that into a web service in PeopleSoft in a few minutes.

Book
Integration Broker - The Missing Manual

I am in the process of writing a book called "Integration Broker - The Missing Manual" that you can read online.