Rick,

RD> IMNSHO it should work like other systems. If I log on to a J2EE
RD> container, and my user ID is associated with the Management role and the
RD> Development role, I get the privileges of both roles, without having to
RD> specify anything.

FWIW I agree with you. Now go and tell the SQL committee... ;-)

If I'm not mistaken, there *is* a feature request along the lines of
allowing to change the current role without having to disconnect and
reconnect, but multiple roles at the same time are against the
standard. That's my recollection.

Ciao
--
Nando mailto:nandod@...