Example: Setting a Query Band for the Current Transaction for a Multistatement Request in a Trusted Session - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

If PROXYUSER and PROXYROLE are set in a query band, the system enforces the privileges for the trusted session to validate the privileges of the individual statements in the multistatement request.

In this example, proxy user pxyuser3 must have the SELECT privilege on taba, tabb, and tabc.

     SET QUERY_BAND = 'PROXYUSER=pxyuser3;' FOR TRANSACTION
     ;SELECT * FROM qbuser.taba
     ;SELECT * FROM qbuser.tabb
     ;SELECT * FROM qbuser.tabc;