Re: WIP: Column-level Privileges

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Markus Wanner <markus(at)bluegap(dot)ch>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: WIP: Column-level Privileges
Date: 2008-11-02 04:50:12
Message-ID: 15479.1225601412@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Stephen Frost <sfrost(at)snowman(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Saito 2008-11-02 05:20:48 Re: [PATCHES] Solve a problem of LC_TIME of windows.
Previous Message Hitoshi Harada 2008-11-02 04:19:37 Re: Windowing Function Patch Review -> Performance Comparison.