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;