Subject | Users and Roles |
---|---|
Author | Nicolas Rodriguez |
Post date | 2007-10-10T19:32:41Z |
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]
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]