Re: column level, uid based authorization to update columns

On Thu, Sep 03, 2009 at 10:17:15AM -0700, Gauthier, Dave wrote:
> In linux, given the linux based uid of the user, how might someone
> implement column level update restrictions on a uid basis?  For
> example...

You can use ident authentication in pg_hba.conf and per-column
GRANT/REVOKE in 8.4.

http://www.postgresql.org/docs/current/static/sql-grant.html

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate