Subject Re: [Firebird-Architect] User name SYSDBA
Author Jim Starkey
Christian Danner wrote:

>But additionally the storage of a role / role set, actually to a
>VAR-/CHAR variable, would have to be considered, IMHO a compatibility
>problem even harder to solve. If the assignment of a NULL-value isn't
>adequate CURRENT_ROLE should at least support a term like 'MULTI' for
>that purpose (in accordance to 'NONE'). In contrast to this a simple
>concatenation of the roles could lead to an overflow of the
>destination, which may not be prepared for such a long string. Enough
>to be figured out by the gurus - if at all.
I implemented an "is active_role(<rolename>)" predicate in
Netfrastructure to address this problem.