Re: GRANT access on table fields - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: GRANT access on table fields
Date
Msg-id 20030228152818.GA7288@wolff.to
Whole thread Raw
In response to GRANT access on table fields  ("Nathalie Boulos" <nathalieboulos@hotmail.com>)
List pgsql-admin
On Fri, Feb 28, 2003 at 12:37:53 +0200,
  Nathalie Boulos <nathalieboulos@hotmail.com> wrote:
> Hi,
>
> is there a way to grant or revoke rights on specific fields of a table for
> specific users?
>
> if yes how is it possibly done and in which versions of postgres?

You need to use views or rules to do this. (You could also use functions,
but I don't think this would be a good idea.)

pgsql-admin by date:

Previous
From: Tycho Fruru
Date:
Subject: Re: Cross-database references
Next
From: Stephen Harris
Date:
Subject: ident sameuser failure