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

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

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.