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

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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;