Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> OS Authentication

OS Authentication

From: Richard Hennessy <rhennessy_at_qumas.com>
Date: 2 Apr 2002 08:41:23 -0800
Message-ID: <13d248d1.0204020841.3eb2de20@posting.google.com>


Hi,

I wonder is it possible to connect multiple users to a database from a single machine using OS Authentication. I can get it working okay when each user connects from their own machine using "connect /@db_alias".

Why I need this is because I have a "Provider" DLL that handles all database queries and passes back the information to a webclient. Users type their username and password at the webclient. This username and password has to be their NT username and password. Problem is this username and password are sent to the Provider layer DLL which connect to the database using ADO and the supplied username and password from the webclient. But I can't get it to work using the OS Authentication (I don't even know if it's meant to work!!) Ideally I would like to be able to supply a username and password for the OS authentication but I don't think this is possible because when I have a user set up in Oracle to be authenticated as "External" and try to log them on using their username (that I already set up) and NT password it gives me "Invalid username/password" because I imagine it is trying to verify against the Oracle password which does not exist.

Assuming what I want to do cannot be done using the "External" authenication method, what other option are available to me so that I can use NT/2000 domain passwords as the Oracle password?

Thank in advance for any help! Received on Tue Apr 02 2002 - 10:41:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US