Login Process of Application Designer:

The 2tier connection 
The 2tier connection is a direct connection to the database. It requires a database client installed onto the workstation and to know the connectid and connectid password (people/peop1e).
Disadvantages of 2-tier connection:
1. If there are many developers or many users with a need of AppDesigner, that could overload the database server.
2. Database client needs to be installed and configured (tnsnames.ora for Oracle db)
3. A database user needs to be known (connectid), which could introduce security issue

The 3tier mode connection 
The 3tier mode connection is a connection through the application server. It requires to configure the WSL port and to activate the WSL listener.
Advantages of 3-tier connection:
1. It moves the load from the database server to the application server (especially good if you can offer a dedicated server for WSL connection)
2. It keeps the database secure (no need to know any database user)
3. No need to install and configure any database client onto the workstation
All the projects (like tables) can’t be built in 3-tier mode.


Login using PS user id.
1. Connection with connectid (people)
2. Check if the database name given in the login screen matched the database name in PSDBOWNER
3. Check if the given user exists as an application user (in PSOPRDEFN)
4. Take the accessid and password for that particular userid (ACCESSID=SYSADM)
5. Reconnect as ACCESSID