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;