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

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.