Grant on multiple objects

Поиск
Список
Период
Сортировка
От Jason Dixon
Тема Grant on multiple objects
Дата
Msg-id C9C91E71-5C0E-11D9-B58C-000D93C63BA8@dixongroup.net
обсуждение исходный текст
Ответы Re: Grant on multiple objects
Список pgsql-novice
Is it possible to GRANT permissions on multiple objects at once?  I
would like to assign limited permissions on multiple objects (tables,
indices, sequences in the same database) without granting full
ownership.  For example, something like this:

GRANT SELECT, INSERT, UPDATE on (SELECT relname FROM pg_class WHERE
relkind in ('r', 'i', 'S') AND relnamespace=2200) to jason;

Is this possible?  I understand from reading the documentation that
this is not in the SQL standard, but I'm hopeful there is some type of
work-around.

Thanks,

--
Jason Dixon
DixonGroup Consulting
http://www.dixongroup.net


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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: adding a new data to existing psql table from comma del file
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Grant on multiple objects