Re: OS authentication
From: Frank <fvanbortel_at_netscape.net>
Date: Thu, 10 Apr 2003 19:31:38 +0200
Message-ID: <3E95AA7A.2060006_at_netscape.net>
>>Didier wrote:
>>
>>>Hi,
>>>
>>>I'm trying to use the OS authentication :
>>>
>>>- Server : Oracle 8.1.7
>>>- Client : ODP.NET 9.2 (and parallel Oracle client 8.1.7)
>>>
>>>I've configured the database server (remote_os_authent=true /
>>>os_authent_prefix = "" and create the user with a role giving access
>>>to the db objects - also connect and create session right).
>>>When using sqlplus with 'sqlplus /_at_myalias', all works fine. When
>>>trying an Open on an OracleConnection in .NET (with the connect string
>>>: "user id=/; data source=myalias"), I become an exception with the
>>>error ORA-01017 (wrong login/password). Using my connection
>>>(OracleConnection) starting with an Oracle identified user works fine.
>>>I'm probably missing something, could someone give me some hints
>>>please ? (I'v also set in registry OSAUTH_PREFIX_DOMAIN to FALSE -as
>>>string key).
>>>
>>>Thanks
>>
>>Now I know Gate$ considers every PC, connected to the web as his own,
>>but do you have _any_ idea what OS user would be used?!?
>>Neither do I, or does Oracle
Date: Thu, 10 Apr 2003 19:31:38 +0200
Message-ID: <3E95AA7A.2060006_at_netscape.net>
Didier wrote:
> Frank <fvanbortel_at_netscape.net> wrote in message news:<3E9471BE.7050409_at_netscape.net>... >
>>Didier wrote:
>>
>>>Hi,
>>>
>>>I'm trying to use the OS authentication :
>>>
>>>- Server : Oracle 8.1.7
>>>- Client : ODP.NET 9.2 (and parallel Oracle client 8.1.7)
>>>
>>>I've configured the database server (remote_os_authent=true /
>>>os_authent_prefix = "" and create the user with a role giving access
>>>to the db objects - also connect and create session right).
>>>When using sqlplus with 'sqlplus /_at_myalias', all works fine. When
>>>trying an Open on an OracleConnection in .NET (with the connect string
>>>: "user id=/; data source=myalias"), I become an exception with the
>>>error ORA-01017 (wrong login/password). Using my connection
>>>(OracleConnection) starting with an Oracle identified user works fine.
>>>I'm probably missing something, could someone give me some hints
>>>please ? (I'v also set in registry OSAUTH_PREFIX_DOMAIN to FALSE -as
>>>string key).
>>>
>>>Thanks
>>
>>Now I know Gate$ considers every PC, connected to the web as his own,
>>but do you have _any_ idea what OS user would be used?!?
>>Neither do I, or does Oracle
> > > OS : W2K (client and server) > User : normal domain user (with admin rights on the client computer) > > Didier
I thought this was (remote) .net? If not - disregard my previous email
-- Regards, Frank van BortelReceived on Thu Apr 10 2003 - 19:31:38 CEST