Re: Schema case sensitive in Oracle?

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