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

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
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.