Re: Grant CREATE privilege on all schemas - Mailing list pgsql-novice

From David G. Johnston
Subject Re: Grant CREATE privilege on all schemas
Date
Msg-id CAKFQuwZMV2njhUjugmmiy_i_=S0XXAYUojzA8oqRgbYnR7z+qw@mail.gmail.com
Whole thread Raw
In response to Grant CREATE privilege on all schemas  (ivanov17@riseup.net)
Responses Re: Grant CREATE privilege on all schemas  (ivanov17@riseup.net)
List 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 by date:

Previous
From: ivanov17@riseup.net
Date:
Subject: Grant CREATE privilege on all schemas
Next
From: Tom Lane
Date:
Subject: Re: Grant CREATE privilege on all schemas