OracleClient Vs. ODP.NET using Lightweight Sessions
Posted on 2003-10-30
Does Microsoft's OracleClient (included with .Net 1.1 framework) support Lightweight session similar to Oracles ODP.net driver? (Proxy Authentication) I know that Lightweight sessions are part of Oracle Call Interface, although I haven't found any documentation on creating a Proxy connection to Oracle with the OracleClient.
Main reason for asking, I want to maintain connection pooling while using different users to connect to oracle so that we can take advantage of Fine Grained Access Control (FGAC or VPD) when connecting from IIS.
My only slution might be to switch to ODP.... Thanks
I hope this question wasn't confusing.