Os authentication with Windows domain user

[kubina]

Hi,

I have receive my first copy of PL/SQL Developer today. It's a great product but I have found my problem.
My computer is in a Windows domain and I have local Oracle 9.2 database. When I am connecting to this database using OS authentication everything seems ok, but when I want to create a test script for function like:
create or replace function first_day(p_day in date) return date is
begin
return(add_months(last_day(p_day)+1, -1));
end first_day;
I receive a following error: ORA-00911 Invalid character.
When I am connecting using db user and password, test script is generated without any problems.
I see following problem:
DB account is OPS$LOGOS\MISINA and character \ can not be used like normal character. It must be used like in this statement: grant select on t to "OPS$LOGOS\MISINA", not to OPS$LOGOS\MISINA. I have tried this in SQL*Plus.
Please help me, if you could. I would really appreciate it.
Thank you for any response.

 

[Marco Kalter]

Sounds like a bug. Maybe we can address this for 5.1.3 which will be released in a few days.

------------------
Marco Kalter
Allround Automations

 

[kubina]

Thank you for quick response.
Do you know any workaround or do I have to use only db user before a new version comes?
Thanks
Jakub Misina

 

[Marco Kalter]

The only workaround I can think of is to not use a backslash in the username.

------------------
Marco Kalter
Allround Automations