Re: [PATCHES] Roles - SET ROLE Updated

Stephen Frost <sfrost@snowman.net> writes:
> * Tom Lane (tgl@sss.pgh.pa.us) wrote:
>> My current reading of 4.31 is that SET ROLE *doesn't* drop rights, which
>> means we need to rethink all of this.  However, on this point:

> Yeah, it seems to add them.  Honestly, my recollection from working on
> Oracle is that you have access to all the roles you've been granted when
> you connect as a user.  If it'd be useful I'd be happy to see about
> finding out exactly what Oracle does in this regard and if it actually
> follows the specification or what.

Yeah, let's take a look.  This wouldn't be the first part of the spec
we've come across that is mostly honored in the breach...
        regards, tom lane