Page 1 of 1

Oracle ASP.NET impersonation

Posted: Thu 20 May 2010 18:25
by Emily
Here's my setup: I am using EF v1, dotConnect for Oracle (latest), and ASP.NET. I want to use Integrated Windows Authentication and pass those credentials to Oracle (Linux).

When I first created my EF model, EF threw this into the .config file:

Code: Select all

 
   
This is a general account. When I deploy my application, I want to use WIndows Authentication to send over those credentials to Oracle. How can I do that? I'm assuming I have to edit my connectionString?

This works fine if I have Windows Authentication set to off (unchecked) and I can perform all CRUD, but now I want impersonation in place and thus when I turn WIndows Authentication on, my queries fail.

Posted: Fri 21 May 2010 15:59
by AndreyR
In case you have Oracle OS Authentication configured correctly, the only thing you need to get this to work is to remove User Id and Password entries from the connection string, like this:

Code: Select all