Changing your SYSADM password can be challenging. Sure you can go to the database and do an alter user to change the PW. But that doesn't effect the password that PeopleSoft stores as the Access ID password.
The old School way, meaning how I've always done it before was to use DataMover (DM) like this:
UPDATE PSACCESSPROFILE SET STM_ACCESS_ID = 'SYSADM', SYMBOLICID = 'SYSADM1', STM_ACCESS_PSWD = ***PDW***', VERSION = 1, ENCRYPTED = 0;
ENCRYPT_PASSWORD *;
While that way can still work, my main problem with it was that not all users in the the PSOPRDEFN table have passwords in all environments. If you issue the ENCRYPT_PASSWORD * command and there are blank passwords, it will fail.
The new (new to me at least) way that I just discovered was by still using DM and issuing:
CHANGE_ACCESS_PASSWORD SYSADM1 ***PWD***
Then you connect with App Designer and just like magic our SYSADM, Access ID password has been updated and encrypted.
Reference:
E-SEC: How To Change The Access ID (SYSADM) Password? (Doc ID 609603.1)
Comments