Re: Lower case username logon problem

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.

Try:

sqlplus \"Test\"/test

The backslashes protect the quotes.

Worked for me on W2KPro XE in a command window, anyways. In the unix world, we consider backslashes an escape character. And what is Windows but a brain-dead unix?

<g,d&r>

jg

-- 
@home.com is bogus.
825 minutes for a scan?  Sheesh.