Re: changing the permission of _lots_ of tables

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: changing the permission of _lots_ of tables
Дата
Msg-id 457FB204.7050104@archonet.com
обсуждение исходный текст
Ответ на changing the permission of _lots_ of tables  ("Roderick A. Anderson" <raanders@acm.org>)
Ответы Re: changing the permission of _lots_ of tables
Список pgsql-general
Roderick A. Anderson wrote:
> Works great ... up to a point.  I now need to change the users and
> owners associated with all the tables without changing their permissions.
>
> Is there a way or hack to do mass changes like these.

Write a small plpgsql function to take a pattern and set permissions
based on that. A quick bit of googling should find some examples for you.

--
   Richard Huxton
   Archonet Ltd

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