17.20 - Setting Up a Permanent Application Logon User - Analytics Database - Teradata Vantage

Teradata Vantageā„¢ - Analytics Database Security Administration - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-03-07
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572

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.