Password Extractor

By Chris Malek | Wed, Oct 13, 2010

This script will extract password as an update statement to be moved to another database. You will need to change the where clause per your requirements.


SELECT 'UPDATE PSOPRDEFN
       SET OPERPSWD = ''' 
       || OPERPSWD || ''', 
       LASTPSWDCHANGE  = ''' | SYSDATE | ''' WHERE OPRID = '''
       || OPRID || ''' ' ;'   FROM PSOPRDEFN
WHERE OPRID IN ('user1', 'user2')
ORDER BY OPRID DESC;
Article Categories

Security

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.

Read More & Purchase
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.

Read Online