Re: Oracle is only case sensitive ?????

On Tue, 18 Feb 2003, DA Morgan wrote:

> Hanne Iren Midttun wrote:
>
> > But, what is a password then?
> >
> > eg: alter user system identified by bigBandA;
> > sqlplus system/bigbanda
> >
> > This works fine for me. (8.1.7.4 and AIX 4.3)
>
> It is NOT a string comparison any more than CREATE TABLE xyz and CREATE TABLE XYZ
> constitutes a string comparison.

It isn't? This is what I tought happend:

alter user system identified by bigBandA (the database uses it's own crypto algoritem to cryptate the password, and store the cryptated string it in the database)

sqlplus system/bigBandA
(The datebase uses it's own crypto arlgoritem to cryptate the password, and then users a *string comparison* against the the stored cryptated string)

regards Hanne

--
Hanne Midttun
http://www.tihlde.org/~hannem

English is not my native tounge