Sunday, March 11, 2012

Change Access Password

The symbolic ID is the account used by PeopleSoft to link users (operators) to the system account which is stored as ACCESSID in the PSACCESSPRFL record and encrypted.
Syntax to change or update password is:
CHANGE_ACCESS_PASSWORD [SymbolicID] [Password]
Alternative Method:
If user(“SYSADM” for Oracle and “SA” for MSS) is altered by the below query,
ALTER USER username IDENTIFIED BY password
then below scripts need to execute.
UPDATE PSSTATUS SET OWNERID = 'SYSADM';
UPDATE PSOPRDEFN SET SYMBOLICID = 'SYSADM1', OPERPSWD = OPRID, ENCRYPTED = 0;
UPDATE PSACCESSPRFL SET ACCESSID = 'SYSADM', SYMBOLICID = 'SYSADM1', ACCESSPSWD = 'SYSADM', VERSION = 0, ENCRYPTED = 0;
GRANT SELECT ON PSSTATUS TO people;
GRANT SELECT ON PSOPRDEFN TO people;
GRANT SELECT ON PSACCESSPRFL TO people;
Now login to Data-Mover in bootstrap mode and execute the below script.
 
REM - ENCRYPT PASSWORD
/
SET LOG d:\dbsetup_log\encrypt.log;
ENCRYPT_PASSWORD *;
/
Note: Make sure Connect-ID (people) account is not locked and correctly entered to configuration manager.

2 comments:

Ajit Vijayakumar said...

This doesnt work. Please dont try it

Pawan Mundhra said...

Thank you Vijay for comment.. I already tested this and worked for me. I am not sure why this didn't work for you. If you think any change happened with recent tools and other solution worked then please do share the solution to all so everyone can get benefit.

Post a Comment