Re: OPS$ on NT : Does it work ?

From: Anand Pandey <anandkp_at_eduserv.its.unimelb.edu.au>
Date: 1998/02/14
Message-ID: <34E54241.C4F0C5D3@eduserv.its.unimelb.edu.au>#1/1

LFB wrote:

> Before installing Oracle 7.3 on NT, and begining some projects, I
> would
> know
> if Oracle 7.3 on NT resolves the connections with
> OPS$<username_from_NT_domain> .
>
> Thanks in advance.
>
> --
> Nicolas Daridan,
>
> DBA Oracle & Unix,Nt Administrator,
>
> LFB, Les Ulis (Paris), France.

Yes, you can have same usercode in Oracle as in Operating System (NT). You have to do so after installing Oracle. I didn't find any connectivity problem. We are using SQL*NET V2.0 (TCP/IP). The user has to enter "/" when Oracle Logon screen appears. Actually it is good to have so because user need not enter same usercode/password twice. To achieve this, you have to create a new usercode in Oracle having same usercode used in Operating system but the new usercode must be prefixed with OPS$. Oracle does not expect any password for this new usercode because it trust the validation done by Operating System. thanks,

-anand pandey
e-mail; anand_pandey_at_iname.com Received on Sat Feb 14 1998 - 00:00:00 CST