| User ID | Symbolic Id | Access Id | Connect Id | |
|---|---|---|---|---|
| Used For | A PeopleSoft user ID is the ID you enter at the PeopleSoft sign-in dialog box. You assign each PeopleSoft user a user ID | Used to map the User Id to Access Id without exposing the Access Id information. All the User Id's are associated with a Symbolic Id (on User Profile Page). A Symbolic Id is associated with Access Id in PSACCESSPRFL record (Access Id is encrypted in this record). | The
PeopleSoft access ID is the RDBMS ID with which PeopleSoft applications
are ultimately connected to your database after the PeopleSoft system
connects using the connect ID and validates the User ID and password. An
access ID typically has all the RDBMS privileges necessary to access
and manipulate data for an entire PeopleSoft application. The access ID
should have Select, Update, and Delete access Users do not know their corresponding access IDs. They just sign in with their user IDs and passwords. Behind the scenes, the system signs them into the database using the access ID. | The connect ID performs the initial connection to the database [RDBMS].Used by 2-tier, App Server, Batch Server to connect the database during Sign-in. |
| Peoplesoft Application Permissions | Obtains all the rights/permission from Roles/Permission Lists | Does not require to have any PS Roles | Full RDBMS rights | Read-only rights to a) PSDBOWNER (For Oracle/DB2) b) PSSTATUS c) PSOPRDEFN d) PSACCESSPRFL |
| Type of Account | Peoplesoft Account | Peoplesoft Account | RDBMS Account | RDBMS Account |
| User exists in Database | No, PeopleSoft no longer creates users at the database level. | No | Yes | Yes |
| Example | ELLISONLARRY | sa | sysadm [Encrypted in PSACCESSPRFL]. Usually it is schema owner. | people |
Ref: http://peoplesoft.mithil.com/2007/09/user-id-symbolic-id-access-id-connect.html
