Monday, 18 May 2020

PeopleSoft: Update user password - Helpful during installation

This is a very simple Data mover script to update a user's password in PeopleSoft
and re-encrypt it.
Useful if you can't access the PIA (e.g. during installation)
but need to update user passwords.

Steps to update the user password.

1) Login into Data mover using Bootstrap mode. (use database access ID and password)
2) Run below script.(in the example, VP2 user password updated and re encrypted).
UPDATE PSOPRDEFN SET PTOPERPSWDV2 = 'VP2', ENCRYPTED = 0, ACCTLOCK = 0
WHERE OPRID = 'VP2';
ENCRYPT_PASSWORD VP2;

PS: This should be done with utmost precautions. Updating userID password
which is part of any configuration can lead to issues in booting application server.





No comments:

Post a Comment