Grant select on all tables in a schema

Поиск
Список
Период
Сортировка
От Bob Hockney
Тема Grant select on all tables in a schema
Дата
Msg-id 40E70477.19775.4A12822@localhost
обсуждение исходный текст
Список pgsql-general
Hi there,

I am using Postgresql 7.3 and I want to grant select rights to a user to all tables in a
schema, even those tables that might be created in the future and whose names are
not yet known, without needing to explicitly grant select rights for each table.  Is this
possible, or does a table need to exist before I can grant a user rights to it?

What I want to do is something like this:

GRANT SELECT ON <schema>.* TO user;

But SELECT isn't valid for schemas.  Any thoughts on how to accomplish this
appreciated.  I am not subscribed to the list so please cc me on replies.

-Bob

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

Предыдущее
От: orfenur@ulrik.uio.no (Rune Froysa)
Дата:
Сообщение: Slow deletion of data from tables
Следующее
От: Mike Rylander
Дата:
Сообщение: Re: Row-level security--is it possible?