Re: Grant CREATE privilege on all schemas

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Grant CREATE privilege on all schemas
Дата
Msg-id CAKFQuwZMV2njhUjugmmiy_i_=S0XXAYUojzA8oqRgbYnR7z+qw@mail.gmail.com
обсуждение исходный текст
Ответ на Grant CREATE privilege on all schemas  (ivanov17@riseup.net)
Ответы Re: Grant CREATE privilege on all schemas  (ivanov17@riseup.net)
Список pgsql-novice
On Mon, Sep 11, 2023 at 6:05 PM <ivanov17@riseup.net> wrote:
But I can't set permissions for
databases and schemas that haven't been created yet.

There are default privileges that can be setup so that when new objects are created existing roles are given the described grants at that time.


Note the absence of DATABASE as an object type on that page.
 
Or maybe there is
another way to organize the process of migrating multiple databases?

And finally, where it would better to create a feature request?

There really isn't such a thing as "feature request" here - there isn't anyone that really makes it a point to fulfill such requests and there is more than manageable work in process already.  That said, discussion about what PostgreSQL can and cannot do, sent to the -general list, do get read by many including developers.

David J.

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

Предыдущее
От: ivanov17@riseup.net
Дата:
Сообщение: Grant CREATE privilege on all schemas
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Grant CREATE privilege on all schemas