Subject Re: [firebird-support] Firebird 2.5 and trusted authentication issue
Author Helen Borrie
At 09:45 a.m. 6/11/2013, marto94114@... wrote:

>I need to use firebird 2.5 and windows trusted authentication.
>I works perfect if my role is one word but if it is more then one it is not working!
>For example:
>I have a domain groups SUPER_USER and GOOD USER. I have the same roles in my database. I am member of both of them as windows domain user.
>When I connect to database with role: "SUPER_USER" (without user and pass) using trusted auth. it works perfect. BUT If I connect with role GOOD USER using trusted auth. firebird logs me in database with public account.
>I can not fidn anything in internet!
>DO firebird 2.5 has problem wirh two or more separated words as role?
>Please help.

Simply put, a role name is an SQL identifier, so it must comply with Firebird's rules for identifiers. If you *really* must have a space in a role name, you'll have to enclose it in double quotes when you define it (that will also make it case-sensitive) AND always include the double quotes when you use it in your applications.

But instead of making a rod for your back (my opinion of quoted identifiers!), why not use the underscore as your separator?

Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"