Subject RE: [firebird-support] Roles in Firebird
Author Helen Borrie
At 10:34 AM 29/07/2004 -0400, you wrote:
> >> - If no, Is there a way to enable this role automatically without
> >> having to specify it during connections?
> >NO.
> >You can have as much roles as you like. So how should the database
>decide which one to use???
>IMNSHO it should work like other systems. If I log on to a J2EE
>container, and my user ID is associated with the Management role and the
>Development role, I get the privileges of both roles, without having to
>specify anything.

You're confusing it with OS group privileges. It's not. It's simply a way
to package a number of privileges that you can grant to a user as a whole
(and revoke as a whole). You don't assign users to roles, you grant roles
to users.

Remember also that Firebird users belong to the server, not to databases.

Good grief, SQL privileges, which were designed by a committee, natch, are
already a Mad Hatter's Teaparty, without making it worse...