Good news for people who always wanted oracle schema passwords to be case sensitive.
Oracle has done this in 11g.
Just to show an example:
C:\Documents and Settings\sachin.arora>sqlplus "/ as sysdba"
SQL*Plus: Release 126.96.36.199.0 - Production on Fri Mar 28 15:02:56 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 188.8.131.52.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create user test identified by AroRa default tablespace users;
SQL> grant create session to test;
SQL> connect test/arora
ORA-01017: invalid username/password; logon denied
SQL> connect test/AroRa
With 11g, Oracle has made significant changes in password maintenence algorithm.
The password verifier is based on 160 bit SHA-1 hashing algorithm. This empowers Oracle to not only allow case sensitive passwords, but also enable the users to keep a strong password that can include special characters.
For pre-11g users, when they migrate to 11g, their password still behave password insensitive. However, i feel its good to take the advantage of this useful feature and change the password.
For applications which cant afford to change their passwords for xyzee purpose, Oracle has supplied an init.ora i.e. SEC_CASE_SENSITIVE_LOGON that can be set to true/false.
Default value of this parameter is true which means passwords should be case sensitive.