| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: column level, uid based authorization to update columns |
| Date: | 2009-09-03 18:02:18 |
| Message-ID: | 20090903180218.GW8410@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shakil Shaikh | 2009-09-03 18:12:11 | Create language PLPERL error |
| Previous Message | Ries van Twisk | 2009-09-03 17:25:01 | Re: column level, uid based authorization to update columns |