Using Trusted Sessions with Requests & Roles | SET QUERY_BAND | Teradata Vantage - Query Bands, Trusted Sessions, and Multistatement Requests - Teradata Vantage - Analytics Database

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-12-13
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jbg1472252759029
lifecycle
latest
Product Category
Teradata Vantage™
The following rules apply to query bands, trusted sessions, and multistatement requests.
  • As is true for non-trusted sessions, a transaction query band must be the first statement specified in a multistatement request.
  • If PROXYUSER and PROXYROLE are set in a query band, then Vantage enforces the privileges defined for the trusted session to validate the privileges of the individual statements in a multistatement request.
  • With the following exceptions, the trusted session privileges are not enforced in a multistatement request.