Re: row level grants

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: row level grants
Дата
Msg-id 9182.1088740774@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: row level grants  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
Bruno Wolff III <bruno@wolff.to> writes:
>   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.

There are working examples of this in the standard distribution.
Take a look at the pg_stats view and the information_schema views.

            regards, tom lane

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

Предыдущее
От: mike g
Дата:
Сообщение: Re: cygpopt-0.dll problem, ipc-daemon2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: max_fsm_pages