Oracle ASP.NET impersonation

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Posts: 13
Joined: Mon 30 Nov 2009 23:45

Oracle ASP.NET impersonation

Post by Emily » Thu 20 May 2010 18:25

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.

Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Fri 21 May 2010 15:59

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


Post Reply