Authorization from Middle Tier | Teradata Vantage - 17.10 - Authentication and Authorization of Middle-Tier Application Users - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2022-02-15
dita:mapPath
ppz1593203596223.ditamap
dita:ditavalPath
wrg1590696035526.ditaval
dita:id
zuy1472246340572

Middle-tier applications are situated between end users and Teradata Vantage. When a middle-tier application accesses Vantage, it must log on as a permanent Vantage user and establish a session pool, after which end users can access Vantage through the application.

All middle-tier application users are authenticated by the application, or the network in which the application resides. For information on session pools, see Teradata Vantage™ - Database Administration, B035-1093.
  • If you implement trusted sessions, you can authorize database privileges for application users individually. For information on establishing trusted sessions and assigning user privileges, see Working with Middle-Tier Application Users.
  • If you do not implement trusted sessions, all application users take on the identity and privileges of the application logon username. This strategy is not recommended because in this situation Vantage is unable to track users as individuals.