Re: grant select on all tables

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: grant select on all tables
Дата
Msg-id 20051025032622.GC16642@wolff.to
обсуждение исходный текст
Ответ на Re: grant select on all tables  (Andrew Borley <BORLEY@uk.ibm.com>)
Список pgsql-novice
On Tue, Oct 04, 2005 at 16:00:38 +0100,
  Andrew Borley <BORLEY@uk.ibm.com> wrote:
>
> Can you set triggers on system catalog tables?

No.

> Are there any alternative ways of doing this?

It might make things easier to use groups so that you can give access to a
group whenever creating any table and then put people in that group that
are supposed to have that access.

If you are worried about people forgetting to do this, you could write a
script that checks for tables that don't have access from that group and
that adds it if needed. You could run the script daily as part of a
cron job.

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

Предыдущее
От: Galliker Armin
Дата:
Сообщение: store images in a database?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: bit map indexes in postgres