> 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:

this is correct - as designed. the login must explicitly declare the role.
WIthout the role, the login is left with whatever permissions have been
granrted to the user (which may be none).

>
> 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?

yes - you can only log on as one role at a a time, so a hierarchy of
permissions is the desinged method of achieving increasing permissions.
Alan

>
> Thanks in advance,
> Nico.-
>
>
> PS: I use Firebird 2.0.3 and Flamerobin 0.7.6.
>