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?
Thanks & Regards,
Joseph.
-----Original Message-----
From: Joseph Bugeja [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 19, 2008 2:35 PM
To: CF-Talk
Subject: Re: Proxy Authentication with Oracle - Does ColdFusion Support th
is?
Hi Dave,
Thanks for your immediate reply.
This is a bit problematic. I think there are workarounds to this but do you
happen to know how this problem can be dealt with? Speaking from a security
perspective, we need to find a way to identify the users that are actually
connected to the database whilst preserving the advantages of connection
pooling. .NET does not have this problem because in the connection string we
can specify both the proxy user and the real users. I know that Oracle has
something that is called the client id, and this could be a possible
solution, but again we need to know what Adobe or CF users recommend.
Regards,
Joseph.
>> In order to have proper auditing and for other benefits like
>
>No, I don't think so.
>
>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:303842
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
