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

From Tom Lane
Subject Re: WIP: Column-level Privileges
Date
Msg-id 15479.1225601412@sss.pgh.pa.us
Whole thread Raw
In response to Re: WIP: Column-level Privileges  (Stephen Frost <sfrost@snowman.net>)
Responses Re: WIP: Column-level Privileges  (Stephen Frost <sfrost@snowman.net>)
Re: WIP: Column-level Privileges  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
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 ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: Re: [PATCHES] Solve a problem of LC_TIME of windows.
Next
From: Oleg Bartunov
Date:
Subject: chinese parser for text search !