When creating a new PeopleSoft webserver domain, PTWEBSERVER is the user id set by default. In order to avoid issues this id should only be used for the webserver domain configuration. If the password for this user id gets changed it may cause the webserver to not boot up. If the PTWEBSERVER password ever needs to be changed, follow the below steps:
Change the online password for PTWEBSERVER:
This can be done by navigating to
PeopleTools Object Versions Record Description PSLOCK This table is used for version control PSOPTIONS This table is used to turn the change control enabling feature on or off. PSVERSION This table holds the version number details
PeopleTools Process Type Details Record Description PS_PRCSDEFN Contains process type and process names PSPRCSLOCK Contains a single record, this gets updated when a process is submitted PeopleTools Process Status Record Description PSPRCSQUE Holds the process request details and should be in sync with PSPRCSRQST. PSPRCSRQST This table holds the process submitted details PS_CDM_LIST Contains the process instance details. Should be in sync with PS_CDM_AUTH PS_CDM_AUTH Contains the process instance details PeopleTools Report Node Details Record Description PS_CDM_DIST_NODE This table holds the report node information which contains the report repository details PS_CDM_DISTSTATUS Contains the definition of report status PeopleTools Batch Server Details Record Description PS_SERVERDEFN Contains the server definitions PSSERVERSTAT Gives information about the batch server status
User Tables Roles Permission Lists PeopleSoft Login Details and Authorization Query Security Tree Example SQL Queries Security is a very important part of any PeopleSoft application. It determines what pages users can see all the way down to which rows. It may seem overwhelming at first but don’t worry; it’s pretty straightforward once you learn all the pieces and how they’re connected.
Below you will find a list of the Main PeopleTools Security Records along with a brief summary of their purpose.
Useful for when the main user id gets locked out. First log into Datamover in bootstrap mode. Then using the script below update the users password.
Note: the script will vary depending on the peopletools version. I forget what the version is exactly, 8.54 I believe.
For earlier versions of PeopleTools:
update PSOPRDEFN set OPERPSWD = 'password', ENCRYPTED = 0 where OPRID = 'OPRID'; -- to encrypt the password encrypt_password OPRID; For later versions of PeopleTools
PeopleTools Version Details Record Description PSRELEASE This table holds the application release details PSSTATUS This table gives the peopletools information
If the PS password has been lost or otherwise hosed, use bootstrap mode to make things right again.
In order to start Datamover in bootstrap mode, use the system access ID and access password. For example by default it’s SYSADM.
Learn how to update a user password including the PS password if needed.
All of the SJT (Security Join Tables) jobs that that joins security information from other tables in the database into a temporary table on the application server for use in business rules.
SJT_OPR_CLS: Contains the User IDs with their data permission lists.
SJT_CLASS_ALL: Contains the data permission information for all the data permission lists that are given data access on the ‘Security by Dept Tree’ page or ‘Security by Permission List’ page.