""Andreas Pohl"" <apohl@...> wrote in message
news:002b01c1ae3c$5e5b7f50$3202a8c0@pc900...

> Is there any chance to support more then one role assigned to a user at

same time in future releases of FB.

>
> (I know it's wrong list to ask but it's right topic.)

But I think that you should have started a new thread to ask it, since it
doesn't fit in the middle of these articles.
Yes, there's a chance... after bending the engine and taking 100 bug reports
for broken functionality introduced by the changes. It has been discussed
previously. Jim Starkey himself proposed that extension.
Since we already have current_role (I tried to attract Borland in the past
to take the same BLR id for that function but didn't raise any interest in
them), it can be extended to report multiple roles, maybe with the same
array operator (the square brackets). The problem is not this part... the
problem is validating the rights inside the db with multiple roles.
:-)
One nicety is that this would be a run-time extension, I mean we probably
don't need to change the ODS or sacrifice compatibility.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing