Re: New patch for Column-level privileges

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
Cc: KaiGai Kohei <kaigai(at)ak(dot)jp(dot)nec(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Markus Wanner <markus(at)bluegap(dot)ch>, Alex Hunsaker <badalex(at)gmail(dot)com>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: New patch for Column-level privileges
Date: 2009-01-09 17:15:11
Message-ID: 20090109171511.GA26233@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jamie, et al,

* Jaime Casanova (jcasanov(at)systemguards(dot)com(dot)ec) wrote:
> <para>
> ! Currently, <productname>PostgreSQL</productname> does not recognize
> ! column-level SELECT privileges when a JOIN is involved.
> One possible workaround is to create a view having just the desired
> columns and then grant privileges to that view.
> </para>

Remove this from the documentation, and:

- Other minor cleanups (thanks KaiGai)
- Added pg_dump support
- Added support for 'ALL(col1)' grant/revokes (helped with pg_dump)
- Added more regression tests
- Updated documentation accordingly

Please test, comment, etc.

Thanks,

Stephen

Attachment Content-Type Size
colprivs_wip.2009010901.diff.gz application/octet-stream 29.9 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2009-01-09 17:16:09 Re: foreign_data test fails with non-C locale
Previous Message Simon Riggs 2009-01-09 17:03:59 Re: Hot standby, RestoreBkpBlocks and cleanup locks