Lower case username logon problem

From: Johnny Williams <REMOVEjohnwilliams_esq_at_NOThotmail.com>
Date: Thu, 12 Oct 2006 13:25:36 +0100
Message-ID: <eglc7j$qsq$1@news.freedom2surf.net>

Hi,

I've created the following username:

CREATE USER "Test" IDENTIFIED BY test;
GRANT CREATE SESSION TO "Test";

Can anyone explain why SQLPLUS "Test"/test and SQLPLUS "Test"/"test" both fail with 'ORA-01017: invalid username/password; logon denied'?

Yet just entering SQLPLUS and entering the username and password at the prompts works:

Enter user-name: "Test"

Enter password:                        (test or "test" typed here)

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> Thanks for any help. Received on Thu Oct 12 2006 - 07:25:36 CDT