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?

Thanks,
Tom