The PeopleSoft login
process through application designer is explained below,
In the Login Window, user has the option to select Type of login.
There if we select Database say Oracle then we are connecting directly to database.
1. User enters the credentials the App designer login window (PS/PS), App designer first connects to database using the connectID provided in the Configuration Manager. Usually, ConnectID will be people.
2. Once connection is
successful, the user ‘people’ issues a couple of select statements on
peopletools Security tables (PSDBOWNER/PSSTATUS/PSACCESSPRFL/PSOPRDEFN) to
validate the credentials provided.
3. Gets the owner name from PSDBOWNER, usually SYSADM. Then checks the tools release.
4. Retrieves the SYMBOLICID (SYSADM1) for the given UserID from PSOPRDEFN.
In the Login Window, user has the option to select Type of login.
There if we select Database say Oracle then we are connecting directly to database.
1. User enters the credentials the App designer login window (PS/PS), App designer first connects to database using the connectID provided in the Configuration Manager. Usually, ConnectID will be people.
3. Gets the owner name from PSDBOWNER, usually SYSADM. Then checks the tools release.
4. Retrieves the SYMBOLICID (SYSADM1) for the given UserID from PSOPRDEFN.
5. Now gets the ACCESSID/PWD (SYSADM) from the
PSACCESSPRFL which is linked to the SYMBOLICID.
6. Disconnects from Database, Connects using AccessID namely SYSADM/pwd. Now App Designer opens and is awaiting user action.
6. Disconnects from Database, Connects using AccessID namely SYSADM/pwd. Now App Designer opens and is awaiting user action.
No comments:
Post a Comment