Setting Up a Permanent Application Logon User - Advanced SQL Engine - Teradata Database

You can set up each application as a single user, for example:

1. Create a permanent database user (logon user) for the application, for example, App1User.
2. 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.