Re: Setting up a fine-grained permission system

Поиск
Список
Период
Сортировка
От Douglas McNaught
Тема Re: Setting up a fine-grained permission system
Дата
Msg-id m28xxg2hpw.fsf@Douglas-McNaughts-Powerbook.local
обсуждение исходный текст
Ответ на Setting up a fine-grained permission system  (David Garamond <lists@zara.6.isreserved.com>)
Список pgsql-general
David Garamond <lists@zara.6.isreserved.com> writes:

> Hi,
>
> Our current project requires a fine-grained permission system (row-level
> and possibly column-level as well). We have a pretty large (tens of
> thousands) of users in the 'party' table. I'm thinking of choosing
> Unix-style security for now (adding 'ugo' and 'owner' and 'group'
> columns to each table which access need to be regulated), but am unsure
> about the column-level permission.

What about creating different views of the table, containing different
columns, with appropriate ACLs?

-Doug

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

Предыдущее
От: Martín Marqués
Дата:
Сообщение: Re: Problems creating view
Следующее
От: "Bob Parkinson"
Дата:
Сообщение: DBI/DBD::Pg mem. use goes exponential