Case sensitive login and password in ODAC 7.20.0.6

VadimShvarts · Post by **VadimShvarts** » Fri 20 May 2011 06:27

Dear users,

New ODAC version 7.20 is available for download now.
This version includes:

...
Case sensitive login and password in the Direct mode is supported
Unicode login and password in the Direct mode is supported
...

I try to check this functionality.

If UserName or Password has character ' ' (space) I could not connect to server.

In OCI mode also.

Oracle server 10.2.0.4.0 or Oracle server 11.2.0.1.0
Delphi XE
ODAC v7.20.0.6 Direct mode

Please fix.

Test project was sended to support devart com

Thanks

AlexP · Post by **AlexP** » Fri 20 May 2011 08:15

hello,

Unfortunately, we did not receive your example, please send it once more to Alexp*devart*com.

I created a user as

Code: Select all

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

and was able to connect successfully in the direct and OCI modes.

VadimShvarts · Post by **VadimShvarts** » Mon 23 May 2011 05:45

I send test project to Alexp

Use test.sql

Code: Select all

create user "Иванов Петр" identified by "русСкий_паРоль";
create user "Иванов_Петр" identified by "русСкий паРоль";

grant connect to "Иванов Петр";
grant connect to "Иванов_Петр";

conn "Иванов Петр"/"русСкий_паРоль"@metatest
conn "Иванов_Петр"/"русСкий паРоль"@metatest

AlexP · Post by **AlexP** » Mon 23 May 2011 07:05

Hello,

As you are creating case-sensitive login and password, and there is the space symbol used, you should use quotes when writing them in ODAC as well as in SQL Plus.

VadimShvarts · Post by **VadimShvarts** » Mon 23 May 2011 09:41

AlexP wrote: As you are creating case-sensitive login and password, and there is the space symbol used, you should use quotes when writing them in ODAC as well as in SQL Plus.

It works.
Thanks