|
|
|
|
|
Home
Members
New Forums
Blogs
Groups
News
Tips
Resources
Books |
How to Change the SYSADM Password
|
SYSADM is the AccessID to the Oracle / PeopleSoft RDBMS. Users can change the SYSADM password anytime. However, the PeopleSoft recommended method of doing this is to change it from within PeopleSoft.
From the application designer, under Tools --> Miscellenous Definitions --> Access Profiles menu.
When done in PeopleSoft, the SYSADM (AccessID) password is embedded and
encrypted in all the PeopleSoft userids. So, all the passwords within
PeopleSoft remain in synch with the SYSADM password in the Oracle system table.
PeopleSoft suggests that you bring down the Application Server before making changes to the SYSADM password. The reason is because any NEW processes that get started by the application server will need to authenticate the OPERID and password again against the database and it may fail if you do not do this.
Changing the SYSADM password at the Back End
People will sometimes want or need to change the SYSADM password from the database side. If you do this by entering SQL Plus and changing the (Oracle or other platform) SYSADM database password, you might find that you cannot get back into PeopleTools, since the password saved in PeopleSoft is still based on the former SYSADM password.
This happens because the SYSADM (AccessID) password is embedded and encrypted in all the PeopleSoft userids, which still contain the old password.
There is a System table in Oracle listing all the valid Oracle user ids.
The entries in this system table must be in synch with the entries in the PeopleSoft table, PSOPRDEFNM. This is the table against which all PeopleSoft Userids are validated.
Once the SYSADM password is changed from the Oracle side, PSOPRDEFN is out of synch with Oracle's system table and PeopleSoft users can no longer login.
If you are using a PeopleTools version above 7.53 you can log into DataMover using your SYSADM AccessID and password and then run the following command:
CHANGE_ACCESS_PASSWORD (AccessID) (newAccessPswd);
This command performs the following operations.
1. Selects the ACCESSPSWD field from PSACCESSPRFL for (AccessID).
2. Changes (AccessID's) database password to (newAccessPswd).
3. Selects each Operator from PSOPRDEFN which uses (AccessID), and for each row returned does the following:
a. decrypts the passwords using (oldAccessPswd).
b. encrypts the passwords using (newAccessPswd).
c. updates PSOPRDEFN with the new encrypted passwords.
4. Updates PSACCESSPROFILE for (AccessID)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Visit our Partner Sites |
|
|
|
|
|
|