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
|
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.
| |
