Re: Using NT Authentication

From: Mike Mattix <dmmattix_at_cmq.com>
Date: 29 Apr 1998 00:37:29 GMT
Message-ID: <6i5so9$p1u$1@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 Tue Apr 28 1998 - 19:37:29 CDT