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

Home -> Community -> Usenet -> c.d.o.server -> Re: Using NT Authentication

Re: Using NT Authentication

From: Eric Logsdon <elogsdon_at_coop-tech.com>
Date: Wed, 29 Apr 1998 10:01:12 -0400
Message-ID: <6i7bq4$j93$1@client3.news.psi.net>


I am currently using named pipes.

Mike Mattix wrote in message <6i5so9$p1u$1_at_kiyoko.communique.net>...
>In article <35458980.A189BDD5_at_bitoek.uni-bayreuth.de>
>Helmut Hahn <Helmut.Hahn_at_bitoek.uni-bayreuth.de> wrote:
>
>> Eric Logsdon wrote:
>>
>>> I have just installed Oracle 8 on a Windows NT4.0 server. I would
>>> like to
>>> use NT authentication for accessing Oracle. I have done the
>>> following:
>>> * sqlnet.authentication_services = (NTS) in sqlnet.ora
>>> * os_authent_prefix = "" in initorcl.ora
>>> * remote_login_password = none in initorcl.ora
>>> * remote_os_authent = true in initorcl.ora
>>> * set registry value
>>> hkey_local_machine\software\oracle\osauth_prefix_domain = true
>>> (rwg_expand_sz)
>>> * set registry value
>>> hkey_local_machine\software\oracle\home0\osauth_prefix_domain = true
>>> (rwg_expand_sz)
>>> * create user "domain\user" identified externally;
>>> * grant connect to "domain\user";
>>> * grant resource to "domain\user";
>>>
>>> I start svrmgr30 and connect /@instance_name and get the message
>>> "ORA-01017:
>>> invalid username/password; logon denied".
>>>
>>> Any help would be appreciated.
>>>
>>> Eric Logsdon
>>> Cooperative Technologies, Inc.
>>> elogsdon_at_coop-tech.com
>>
>> You must have a valid connection (drive mounted) to the server. This
>> makes the 'OS_AUTHENT', this means as you can
>> access a drive on the server you can access the db under this account.
>>
>> Helmut
>
>Actually I have seen that this was a requirement when using an 'Unsecured'
>protocol (like TCP/IP) in versions under 7.3.3. I have read where 7.3.3
and
>above dropped this requirement. Eric is using some 8.0.n variant
(SVRMGR30)
>so this probably is not his problem. I believe you just have to use the
user part
>of the domain\user. At least that is all I use and it works for me.
>
>YMMV
>
>Mike
>
>D.M.(Mike) Mattix
>dmmattix_at_cmq.com
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
Received on Wed Apr 29 1998 - 09:01:12 CDT

Original text of this message

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