17.00 - 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.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
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;