How can I restore a corrupted PeopleSoft password using VigilEnt Password Manager for Oracle?
VigilEnt Password Manager for Oracle 5.0
VigilEnt Password Manager for Oracle 6.x
VigilEnt Security Agent for Oracle 1.x
The steps are outlined below for restoring corrupted PeopleSoft passwords:
These steps are designed for the following combination of VPMO and Oracle versions:
- VPMO v5 & v6 on an Oracle 7.x database
- VPMO v5 on an Oracle 8.x database.
NOTE: These steps were NOT designed for VPMO v6 on an Oracle 8.x database.
- Clear the pwd history for the ID.
- Log onto a SQL session as SYSADM or any privileged user and run the following SQL:
update sqlcqr.sqlcqr_userdata set pwdhist = NULL where username = 'THEUSERID';
- Log onto a SQL session as SYSADM or another privileged user and run the included SQL. This will change the Oracle password directly.
alter user XXX identified by XXX;
- Log onto a SQL session as SYSADM or another privileged user and run the included SQL. This will set the new password value into the PeopleSoft PSOPRDEFN table.
set OPERPSWD='XXX', ACCESSPSWD='SYSADM', ACCESSACCTPSWD='UNENCR'
NOTE: Change SYSADM to your local access id if different. ACCESSACCTPSWD='UNENCR' is the value for PeopleSoft 7.x, substitute ENCRYPTED=0 FOR VERSION 7.5.
- Logon to the datamover as SYSADM or privileged user and execute the following command exactly as shown:
This ID should now be able to log into PeopleSoft.