Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Lower case username logon problem
> On Oct 12, 8:25 am, "Johnny Williams"
> <REMOVEjohnwilliams_..._at_NOThotmail.com> 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.
>
"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:1160665640.744274.234600_at_i3g2000cwc.googlegroups.com...
> Using Oracle version 9.2.0.6 running on AIX 5.2 I was able to connect
> from the UNIX command line using:
> sqlplus "id"/"password"
> sqlplus "id/password"
> sqlplus "id"/password
> sqlplus id/"password"
>
> Tough my ID was not created using double quotes around it in the
> create, that is, create user id ... was used instead of create user
> "id".
All the above variations also work for me (Windows XP SP2) when no quotes are used in the CREATE USER statement, i.e. CREATE USER Test IDENTIFIED BY test;. Obviously, without the quotes Oracle translates the username to upper case characters.
thanks, Received on Thu Oct 12 2006 - 12:34:40 CDT