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

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;