Re: WIP: Column-level Privileges - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: WIP: Column-level Privileges
Date
Msg-id 20081102131332.GU4452@tamriel.snowman.net
Whole thread Raw
In response to Re: WIP: Column-level Privileges  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: WIP: Column-level Privileges  (Markus Wanner <markus@bluegap.ch>)
List pgsql-hackers
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Stephen Frost <sfrost@snowman.net> writes:
> > ... A case I just realized might be an issue is
> > doing a 'select 1 from x;' where you have *no* rights on x, or any
> > columns in it, would still get you the rowcount.
>
> Well, if you have table-level select on x, I would expect that to work,
> even if your privs on every column of x are revoked.  If the patch
> doesn't get this right then it needs more work ...

Attached patch has this fixed and still passes all regression tests,
etc.

    Thanks,

        Stephen

Attachment

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: WIP: Column-level Privileges
Next
From: "David Rowley"
Date:
Subject: Re: Windowing Function Patch Review -> Performance Comparison.