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

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

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;