By | 13 October 2010

Password Extractor

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