Re: New patch for Column-level privileges - Mailing list pgsql-hackers

From Tom Lane
Subject Re: New patch for Column-level privileges
Date
Msg-id 28398.1231868010@sss.pgh.pa.us
Whole thread Raw
In response to Re: New patch for Column-level privileges  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Stephen Frost <sfrost@snowman.net> writes:
> * Tom Lane (tgl@sss.pgh.pa.us) wrote:
>> Oh, I didn't see that.  Still, this doesn't test whether the behavior
>> is correct with respect to ADD/DROP COLUMN --- if that were implemented
>> like SELECT * you'd not see any change in the regression result.

> Hrm.  If a column is added and you're not granted SELECT rights on it
> (even if you have access to all the originals), it should start failing
> for you.  I can certainly add a test case to cover that though.  Or is
> that not the behavior you're expecting?

Right, and conversely dropping the last non-granted column should make
it work.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Latest version of Hot Standby patch
Next
From: Josh Berkus
Date:
Subject: Re: [BUGS] Status of issue 4593