We have a database that sets a column called MOD_BY = CURRENT_USER to almost all tables on INSERT and UPDATE.
But now that the application is n-tier, and uses connection pools, the current_user no longer reflects the 'application user'.
Is there any way to temporarily alter 'current_user' with an alias for the duration of a transaction? IE
...<set current_user = 'application user alias'>...
Any other suggestions on how to transition end-user identity in a connection pool environment?
Thanks, Jack
![](http://www.guest-tek.com/images/signature_logo.gif) | |
Guest-Tek (TSX:GTK) is a global provider of technology solutions to the hospitality industry. Endorsed by more major hotel chains than any of its competitors, Guest-Tek has installed its solutions in more than 570 hotels worldwide. |