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
Book
Integration Broker - The Missing Manual

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

Read Online