Re: Authentication differences between Oracle 8i and 9i

Hi sybrand:

Thanks for your comments. I am not talking about connect internal. connect dummy/""@gisora817 logs me in as OPS$FRED no matter which machine I am on. As long as the Windows user is FRED. If I am logged in to windows as CATHY then using the exact same syntax connect dummy/""@gisora817 logs me in as OPS$CATHY.

I do not know why this does not work in Oracle 9i.

Thanks & Regards,
Satinath

sybrandb_at_yahoo.com wrote in message news:<a1d154f4.0402170420.3916e3c0_at_posting.google.com>...
> ssarkar_at_orion-gis.com (Satinath Sarkar) wrote in message news:<a722f987.0402160913.478006dc_at_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.
> >
> >
> Can't see any problem. The user dummy is password authenticated, so
> you *must* provide a password, and obviously you don't.
> If you came in without password in the past, that must have been on
> the server itself. On the server itself,if your os user is in the
> ORA_DBA group,you can provide *anything* and you will get in. This is
> equivalent to 'connect internal'. However connect internal doesn't
> exist anymore in 9i, and you must use an username/password combo with
> SYSDBA privilege.
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Thu Feb 19 2004 - 15:07:00 CST