Re: Schema case sensitive in Oracle?

Obviously there are ways, through the use of "", lower(), upper(). We're currently using some parts of our application as case sensitive.

But, unlike SQL Server for one, there is no "switch" to make Oracle case sensitive.

Alex Ivascu

"Ranga Chakravarthi" <ranga_at_removethis.cfl.rr.com> wrote in message news:uoC29.194358$XH.4483777_at_twister.tampabay.rr.com...
> Yes, it is possible.
>
> It is the password that is not case sensitive.
> You can make the userid case sensitive by enclosing it in double quotes.
> But you would have to always use the double quotes for loggin in and
> referncing the schema objects. (More confusion, IMHO, an unneccassary one)
>
> SQL> create user "lower" identified by "lower"; <- Notice the double
 quotes
>
> User created.
>
> SQL> grant create session to "lower"; < double quotes again
>
> Grant succeeded.
>
> SQL> connect "lower"/lower; <- you need the double quotes just for the
> userid
> Connected.
> SQL> connect lower/lower; <- Entry implicitly converted to upper case
> ERROR:
> ORA-01017: invalid username/password; logon denied
>
> Warning: You are no longer connected to ORACLE.
> SQL> connect "lower"/"LOWER" <- Password is not case sensitive
> Connected.
> SQL> connect / as sysdba
> Connected.
> SQL> create user "Lower" identified by lower; <- This user is different
 from
> user "lower"
>
> User created.
> SQL> create user lower identified by lower; <- by default implicit
> conversion takes place
>
> User created.
>
> SQL> select username from dba_users
> 2 where upper(username) = 'LOWER';
>
> USERNAME
> ------------------------------
> lower
> Lower
> LOWER
>
> SQL>
>
>
> "Alex Ivascu" <alex_at_ivascu.comNOSPAM> wrote in message
> news:elz29.31403$Ru5.11176_at_rwcrnsc52.ops.asp.att.net...
> > There is no setting in Oracle to set it to case sensitive. And, no you
> > can't have two schema's w/ the same name - in one database either. Hope
> > this helps.
> >
> > Alex Ivascu
> >
> >
> > "Wormie" <ordeith_at_coruscant.net> wrote in message
> > news:df31f670.0208020716.64f0ecea_at_posting.google.com...
> > > Is it possible to have two schemas of the same name, with different
> > > case sensitivities?
> > >
> > > Thanks
> >
> >
> >
>
>
Received on Fri Aug 02 2002 - 23:32:04 CEST