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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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