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
|
| Список | 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 по дате отправления: