You can set up each application as a single user, for example:
- Create a permanent database user (logon user) for the application, for example, App1User.
- Create a profile and one or more roles for the application logon user. Use the PASSWORD option in the profile to set the PasswordExpire parameter to 0 for the application, to prevent the application password from expiring, which could cause a disruption in service for application end user.
After the application logs on and initiates a session pool, all application end users share the logon user identity and privileges.