Re: [PATCHES] Roles - SET ROLE Updated - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: [PATCHES] Roles - SET ROLE Updated
Date
Msg-id 20050721213810.GK24207@ns.snowman.net
Whole thread Raw
In response to Re: [PATCHES] Roles - SET ROLE Updated  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> 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...

Oracle appears to mostly follow it, except there's an implicit
'SET ROLE all;', at least in the instance I'm looking at.  I'm guessing
it's probably something which is tunable.  We don't currently have a way
of having certain roles turned on and certain ones turned off for a
given session.  That doesn't seem like it'd be a very hard thing to add
though.  I have to apologize for not realizing this sooner and
implementing it correctly the first time, sorry about that..
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [PATCHES] Roles - SET ROLE Updated
Next
From: Stephen Frost
Date:
Subject: Re: [PATCHES] Roles - SET ROLE Updated