Re: GRANT access rights on rows - Mailing list pgsql-novice

On Thu, Jan 05, 2006 at 08:25:17 +0000,
  Andrew Chambers <andychambers2002@yahoo.co.uk> wrote:
> On 23:56 Wed 04 Jan     ,  Jaromír Kamler wrote:
> > Hallo,
> > I need GRANT some privilegies to one row. I know, that it si possible to do that for columns, but I do not know how
doit for rows. Any ideas? 
> >
> I believe the conventional method of doing this is to create a view
> selecting all the rows you wish to make accessable, then to grant access
> to the view.

And note that the view can use current_user which may be useful if different
users are supposed to see different rows.