16.10 - Setting Up a Permanent Application Logon User - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

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.