In reality, connection pooling with proxy authentication should automatically create a second session, a lightweight session, with the actual user id and password. Naturally, the dba must grant the proxy user connect rights on the database for this to work.
I did not investigate but I think, as was suggested, we need to create our own JNDI data-source for this to work, and then find a way to dynamically inject the specific settings. -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 8:51 PM To: CF-Talk Subject: RE: Proxy Authentication with Oracle - Does ColdFusion Support th is? > But isn't that what the OP wanted? The ability to have > auditing based on user authentication over the datasource and > the session it creates (not just as a login to a table)? > Wouldn't a datasource created at the J2EE server behave the > same way? I would assume that the ASP pool would work the > same way. I'd be curious to see how it would run under load > testing. No, the OP wanted to use proxy authentication, which would let you have a single connection pool with a single username and password, but would also let you track the Oracle account using a specific connection from that pool by its own specific username and password. This is an Oracle-specific feature, which requires manipulation of the connection string at runtime to include the proxy authentication attributes. 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:303959 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
