Re: row level grants

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: row level grants
Дата
Msg-id 20040701231031.GB9893@wolff.to
обсуждение исходный текст
Ответ на row level grants  (Alexander Cohen <alex@toomuchspace.com>)
Ответы Re: row level grants  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Thu, Jul 01, 2004 at 17:09:23 -0400,
  Alexander Cohen <alex@toomuchspace.com> wrote:
> Is there any way to grant user access at the row level? Or maybe some
> way to simulate it?

You can do this with views. You need something in each row that will
allow you to tell which users have access to a row and check that
against current_user in the view. If there is more than one user
per row, then you might need to join the table to another table
that maps users to groups.

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: permissions
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: postgresql +AMD64 +big address spaces - does it work?