You cannot make Oracle's username or passwords case sensitive. The functionality simply is not there.
Oracle does not store the user's password. If you query DBA_USERS, you
will see two columns, USERNAME and PASSWORD. You will be able to
clearly see the user's name. However, the password is an encrypted,
one-way hash. There is no inverse function for this. So what you see
will not be readable. This information is stored as soon as the user is
This was first published in April 2004