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

-----Original Message-----
From: Lucas Franzen [mailto:luc@...]
Sent: Thursday, July 29, 2004 10:06 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Roles in Firebird


Sergio,


smace_br schrieb:

> Subject: Roles in Firebird
>
> I have created one firebird role (using FB15), and I have specified
> some grants for this role.
>
> - Do I need to specify this role during connection to the DB?

YES

> - Or does it get active automatically?

NO

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

And keep in mind that you have to assign user(s) to the role!!

Luc.





Yahoo! Groups Links