Understanding Connect ID and the PeopleSoft Login Process

When logging into a PeopleSoft database in two-tier mode, the user enters a Database Name, User ID, and Password in the PeopleSoft Signon dialog box. This table lists the steps and related database SQL operations associated with logging in.

Log-in Processing Steps	Related Database SQL Operations
The access to the PeopleSoft Database is established with the Connect ID not the User ID.	Connect=PTDMO/<ConnectID>/<ConnectIDPassword>
Check PSSTATUS	SELECT OWNERID, TOOLSREL, LASTREFRESHDTTM, LASTCHANGEDTTM FROM PSSTATUS
Validate the User ID and Password	SELECT VERSION, OPERPSWD, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM PSOPRDEFN WHERE OPRID = :1
Get the Access ID and Password	SELECT ACCESSID, ACCESSPSWD, ENCRYPTED FROM PSACCESSPROFILE WHERE SYMBOLICID = :1
Disconnect Connect ID	Disconnect
Login using the Access ID	Connect=PTDMO/ACCESSID/ACCESSPWD

At this point, access is governed by PeopleSoft security, which determines what applications a specific user ID has access to.