| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | ivanov17(at)riseup(dot)net |
| Cc: | pgsql-novice(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Grant CREATE privilege on all schemas |
| Date: | 2023-09-12 01:42:56 |
| Message-ID: | CAKFQuwZMV2njhUjugmmiy_i_=S0XXAYUojzA8oqRgbYnR7z+qw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Mon, Sep 11, 2023 at 6:05 PM <ivanov17(at)riseup(dot)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.
https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2023-09-12 02:04:41 | Re: Grant CREATE privilege on all schemas |
| Previous Message | ivanov17 | 2023-09-12 01:05:30 | Grant CREATE privilege on all schemas |