Example: Initiating a Trusted Session Using a Transaction Query Band - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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;