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

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
jpx1556733107962.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1184
lifecycle
previous
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 Teradata Database 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.