Re: GRANT access rights on rows

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: GRANT access rights on rows
Дата
Msg-id 20060105084231.GB32572@wolff.to
обсуждение исходный текст
Ответ на Re: GRANT access rights on rows  (Andrew Chambers <andychambers2002@yahoo.co.uk>)
Ответы Re: GRANT access rights on rows  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список 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.

В списке pgsql-novice по дате отправления:

Предыдущее
От: Andrew Chambers
Дата:
Сообщение: Re: GRANT access rights on rows
Следующее
От: First Last
Дата:
Сообщение: can't connect to postgresql via phppgadmin and pgaccess