17.00 - Example: Initiating a Trusted Session Using a Transaction Query Band - 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)

Using the transaction query band, you can change the proxy user within an explicit Teradata session mode transaction. In this example, proxy user bob initially has the INSERT privilege on bobs_table, but then that query band is replaced within the transaction with a new query band that enables proxy user joe to have the INSERT privilege on joes_table.

At first glance this example seems trivial, but the capability it demonstrates is very useful for use with Java applets.

     BEGIN TRANSACTION;
       SET QUERY_BAND = 'PROXYUSER=bob;' FOR TRANSACTION;
       INSERT INTO bobs_table VALUES(1, 2, 3);
       SET QUERY_BAND = 'PROXYUSER=joe;' FOR TRANSACTION;
       INSERT INTO joes_table VALUES(a, b, c);
     END TRANSACTION;