At 06:51 AM 18/06/2010, you wrote:

>Hi,
>
>I can't see how to grant a role to a user that is logging in using OS Authenticaton (v2.1.3). This document suggests it is straight-forward:
>
>http://ftp.uni-erlangen.de/pub/firebird/doc/README.trusted_authentication.txt
>
>
>"...
>
>select CURRENT_USER from rdb$database;
>you will get something like:
>
>USER
>====================================================
>SRV\John
>
>Windows users may be granted rights to access database objects and roles in the same way as traditional Firebird users.
>..."
>
>So, I try GRANT xxxrole to SVR\John (with/without single + double quotes or variations) and FB doesn't like it.
>
>Can someone point me to the correct syntax please?

GRANT xxxrole to "SVR\John"

(double quotes, not single, because user names conform to the rules for identifiers, not data)

./heLen