Subject Users and Roles
Author Nicolas Rodriguez
Hi all, I been using firebird for less than a month and I'm really happy
with it. I can't find documentation on Roles. I've created a role and
assigned it to a user but it only works if I connect the user an explicitly
use the role name. Let me put it like this:

1) I connect the user to the firebird database as user/password. It doesn't
have the permission assigned to the role "role1" (for example).
2) If I connect the same user to the database as user/password/role it does
have the permissions granted to the role "role1".

Can I just connect the user as user/password and automatically get the
permissions to all the roles assigned to the user as it is in MS SQL Server
for example?
If I have a user with two roles, do I have to create a "meta-role" and
assing both roles to it, and then grant this meta-role to the user?

Thanks in advance,
Nico.-


PS: I use Firebird 2.0.3 and Flamerobin 0.7.6.


[Non-text portions of this message have been removed]