Skip site navigation (1) Skip section navigation (2)

Re: GRANT access rights on rows

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Andrew Chambers <andychambers2002(at)yahoo(dot)co(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: GRANT access rights on rows
Date: 2006-01-05 08:42:31
Message-ID: 20060105084231.GB32572@wolff.to (view raw or flat)
Thread:
Lists: pgsql-novice
On Thu, Jan 05, 2006 at 08:25:17 +0000,
  Andrew Chambers <andychambers2002(at)yahoo(dot)co(dot)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 do it 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.

In response to

Responses

pgsql-novice by date

Next:From: A. KretschmerDate: 2006-01-05 08:48:53
Subject: Re: can't connect to postgresql via phppgadmin and pgaccess
Previous:From: First LastDate: 2006-01-05 08:36:58
Subject: can't connect to postgresql via phppgadmin and pgaccess

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group