Many thanks Helen - works perfectly.

Tom

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> 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
>