Re: Lower case username logon problem

From: Johnny Williams <REMOVEjohnwilliams_esq_at_NOThotmail.com>
Date: Thu, 12 Oct 2006 18:39:55 +0100
Message-ID: <eglula$6tb$1@news.freedom2surf.net>

> Johnny Williams wrote:

>> 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.

"Brian Peasland" <dba_at_nospam.peasland.net> wrote in message news:J717pD.t8_at_igsrsparc2.er.usgs.gov...

> In Oracle 9.2.0.7 on Solaris, I get the same results you did. I cannot 
> answer *why* this is occuring. Maybe SQL*Plus is doing something different 
> when the username is a command line parameter as opposed to the response 
> to a question.

At least it's consistent across platforms (my example was on Windows XP SP2), though rather illogical that it doesn't work when the username in quotes is specified on the command line.

> But the real reason I am writing this is to question why you are trying to 
> create a username that is case sensitive? To me, this is asking for major 
> confusion down the road. Why not use all upper case as Oracle defaults to?

I am used to MS SQL Server which is case sensitive, but will take your advice and use all upper case. My script won't work otherwise!

thanks, Received on Thu Oct 12 2006 - 12:39:55 CDT