Change Access Password

Datamover includes a command called CHANGE_ACCESS_PASSWORD. The purpose of this command is to reset the database password in the PSACCESSPRFL record for the database system user that typically owns the PeopleSoft schema (e.g. SYSADM for Oracle or sa for Microsoft SQL Server). Effectively, it is a way of synchronising a change in the database system user password for these accounts with

A typically use for this command might be the scenario of refreshing databases. The SYSADM or sa account in production will likely have a different password to a test PeopleSoft environment for security reasons. In order to ensure that the refresh works correctly, part of the refresh process includes issuing the CHANGE_ACCESS_PASSWORD command to update the PSACCESSPRFL record accordingly.

The syntax for the command is:

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.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License