Re: Authentication differences between Oracle 8i and 9i

From: Satinath Sarkar <ssarkar_at_orion-gis.com>
Date: 16 Feb 2004 09:13:44 -0800
Message-ID: <a722f987.0402160913.478006dc@posting.google.com>

Thanks Michel. This value is already false.

I have no problem with connecting to either databases using the syntax connect /@gisora817 or connect /@gisora920. Both of these works.

The difference that I have is connect dummy/""@gisora817 logs in the user as OPS$FRED in Oracle 8i. while connect dummy/""@gisora920 does not connect in Oracle 9i.

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:<402e4579$0$28136$626a14ce_at_news.free.fr>...
> Add the following value:
> OSAUTH_PREFIX_DOMAIN=FALSE
> in your registry in the
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME<n>
> key for the 9i oracle home.
>
> This value is false by default in 8i and true in 9i.
> It tells if the domain name must be include or not in the user name for the
> external identification. The value of true is certainly most secure as it allows
> only the user in the specified domain to connect without a password.
>
> Regards
> Michel Cadot
Received on Mon Feb 16 2004 - 11:13:44 CST