PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Encrypting password using Data mover

Hi,

I was successful resetting password in the database

UPDATE PSOPRDEFN SET OPERPSWD = ‘NEWPASSWD’, ENCRYPTED = ‘0’ WHERE OPRID = ‘PS’;

When I login to Data Mover to encrypt the password

It was not encrypting message "unable to update password field' please make sure to use PTOPERPSWDV2 ....

We have PTOOLS Ver 8.56

PeopleSoft application 9.2

I also tried the password script

UPDATE PSOPRDEFN SET PTOPERPSWDV2 = OPRID, OPERPSWDSALT=' ', ENCRYPTED = 0 WHERE PTOPERPSWDV2 <> ' ';

values

UPDATE PSOPRDEFN SET PTOPERPSWDV2 = 'PS', OPERPSWDSALT='MYPASSWORD ', ENCRYPTED = 0 WHERE PTOPERPSWDV2 !=  ' MYPASSWORD';

Result : updated 223,000 users not only PS account so had to rollback.

Can you please let me know what is the correct way of 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center