Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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
>
I think the crux is, that when you surround a command-line parameter with quotes (in windows) the called program will NOT see the quotes.
Try notepad.exe "test.ext1" ... notepad.exe "test".ext2 ... notepad.exe "test with space.txt"
cheers,
Martin
Received on Thu Oct 12 2006 - 15:56:48 CDT