> Is there a workaround? > > Speaking of .NET/C#, to discern the identity of the actual > user while keeping the benefits of pooling, the following two > approaches can be used: > > Proxy Authentication using C#: > > String oradb = "Data Source=OraDb;User > Id=ActualUser;Password=secret; Proxy User Id=scott;Proxy > Password=tiger; "; > > OR > > Client Identifier using C#/Oracle: > > conn.ClientId = "SomeUser"; > > Is there a similar method in ColdFusion?
I'm not aware of any workaround (although that doesn't mean there isn't one). The problem is that CF doesn't let you build your connection string dynamically. You create a datasource, which builds your connection string for you. I'm not aware of any way to inject variables in that string at runtime, or to build a connection string at runtime, while continuing to use CF datasources. You might be able to create a JNDI datasource in JRun or whatever J2EE app server you're using, and reference that from within CF, and set/use the variables with that. That's the approach I'd investigate, I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303886 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
