> while the SQL standard that you love too much probably doesn't talk
> about switching roles in run-time without disconnecting from the db, there's
> a static provision: the SQL standard caters for roles that can be granted to
> roles. So, this is poor's man way to have several roles assigned. The

IIRC SQL standard allows switching roles in run-time by SET ROLE ... command.

Ivan
prenosil@...
http://www.volny.cz/iprenosil/interbase