Grant Select privileges for all tables in schema

Поиск
Список
Период
Сортировка
От zeus@ix.netcom.com
Тема Grant Select privileges for all tables in schema
Дата
Msg-id 8717756.1089153842355.JavaMail.root@statler.psp.pas.earthlink.net
обсуждение исходный текст
Ответы Re: Grant Select privileges for all tables in schema  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
Hi there,

I am using Postgresql 7.3 and I want to grant select rights to a user on all tables in a schema, including those that
maybe created in the future but whose names are not yet known.  I want to do something like: 

GRANT SELECT ON <schema>.* TO <user>;

but select isn't a valid privilege on a schema and I don't see how wildcards are supported.  Is there a way to do this,
ordoes a table need to exist before a user can be granted rights to it, and users must be explicitly granted rights to
eachtable and not in a 'global' way.   I would appreciate any thoughts on this. 

-Bob

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

Предыдущее
От: Tony Li
Дата:
Сообщение: Syntax question
Следующее
От: Clodoaldo Pinto Neto
Дата:
Сообщение: Re: could not access file "$libdir/plpython" when restoring