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

Teradata Vantage™ - Advanced SQL Engine Security Administration

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

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.