I need help with using Integrated Security to an Oracle DB from a Web Service
From: TMarkham1 (TMarkham1@aol.com)
Date: 08/26/02
- Next message: Fred Figueiredo: "Login Security ASP.NET - Need help on a idea - Thanks"
- Previous message: Willy Denoyette [MVP]: "Re: Problem with execution of an extern program from an asp.net application."
- In reply to: TMarkham1: "I need help with using Integrated Security to an Oracle DB from a Web Service"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "TMarkham1" <TMarkham1@aol.com> Date: Mon, 26 Aug 2002 09:59:52 -0700
Never mind, I found the answer. Impersonation.
>-----Original Message-----
>OK, here's the deal. I would like to use Integrated
Security (Windows
>Security) when connecting to an Oracle database from an
XML Web Service. Any
>suggestions on how to do this would be greatly
appreciated!
>
>My current setup includes 3 computers. All computers are
in the same Windows
>Domain.
>
>"Machine A" is our Oracle Database server. It is running
Windows 2000 Server
>and Oracle 8i.
>
>"Machine B" is a PC running Windows 2000 Professional
with IIS running on
>it. It also has the Microsoft Oracle Managed Data
Provider and the Oracle 8i
>client installed and it hosts the XML Web Service.
>
>"Machine C" is a PC running Windows 2000 Professional. It
is running a .Net
>Windows Application that references an XML Web Service
on "Machine B".
>
> I was successful in connecting to the Oracle database
(using Integrated
>Security) from a small Windows Application I built and
ran from "Machine B"
>(not using the Web Service), so I know the Oracle
Database is setup
>correctly to perform this function. I setup "Machine B"
to use Windows
>Authentication, and it validates access to the Web
Service methods prefectly
>(I can actually return information from a method that
doesn't access the
>Oracle Database).
>
>The problem I am having occurs when the XML Web Service
accesses the Oracle
>Database after a domain user authenticates with the XML
Web Service. The Web
>Service is attempting to access the Oracle database using
the "ASPNET" user
>account, and therefore it fails.
>
>How do I get the Web Service to pass the credentials of
the authenticated
>domain user to the Oracle database instead of
using "ASPNET"? Is this even
>possible? Or, am I opening up a can of worms with this
one?
>
>
>
>
>.
>
- Next message: Fred Figueiredo: "Login Security ASP.NET - Need help on a idea - Thanks"
- Previous message: Willy Denoyette [MVP]: "Re: Problem with execution of an extern program from an asp.net application."
- In reply to: TMarkham1: "I need help with using Integrated Security to an Oracle DB from a Web Service"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
