Why not just set it in their session and then you are only setting it once and referencing that for each query you execute.
On Tue, Jul 22, 2008 at 9:06 AM, Joseph Bugeja <[EMAIL PROTECTED]> wrote: > Dave, > > That's exactly what I was looking for - proxy authentication. I created a > thread on this forum about this but the reply I got is that ColdFusion does > not natively support this. So, the solution is to either create our own JNDI > datasource using Java. However, I decided to not go this way and instead set > the client identifier prior to executing each query. This should work and > according to my testing it does not inflict a heavy performance degradation. > > >Joseph, > > > >I did some googling and found that Oracle has 'proxy user authentication'. > >See this Ask Tom article (someone wanting to do the same thing as you are, > >but in java): > > > >http://tinyurl.com/6qe8xk > > > >Although I don't know if you can do it with the ColdFusion setup directly, > >but maybe you can access some underlying java component to do it. > Hopefully > >this might give you another alternative. Let me know how it turns out. > > > >Dave > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309458 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4