Skip to content

Peoplesoft "sysadm" backend procedure for password change

July 15, 2010
Below is the simple procedure to change sysadm account from the database.This can be done from application designer as well.
1.
Select * from PSACCESSPRFL;
SYMBOLIC VERSION ACCESSID ACCESSPSWD ENCRYPTED
——– ———- —————- —————- ———-
SYSADM1 **************** **************** 1
2.
alter user sysadm identified by *******;
update PSACCESSPRFL set ACCESSID = ‘what your Access ID is’ , ACCESSPSWD = ‘your New Access Password’ , ENCRYPTED = 0, where SYMBOLICID = ‘whatever the SYMBOLICID is’;
3.
update PSACCESSPRFL set ACCESSID = ‘SYSADM’ , ACCESSPSWD = ” , ENCRYPTED = 0 where SYMBOLICID = ‘SYSADM1’;
4.
Select * from PSACCESSPRFL;
SYMBOLIC VERSION ACCESSID ACCESSPSWD ENCRYPTED
——– ———- —————- —————- ———-
SYSADM1 1 SYSADM *********** 0
5.Alter the user password in database level.
alter user sysadm account unlock;
6.
Restart the application server for the environment or login from the application designer.
7.
Select * from PSACCESSPRFL;
SYMBOLIC VERSION ACCESSID ACCESSPSWD ENCRYPTED
——– ———- —————- —————- ———-
SYSADM1 ***************** **************** 1
Advertisements

From → PeopleSoft

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: