public inbox for [email protected]  

help / color / mirror / Atom feed

From: David G. Johnston <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Re: Grant CREATE privilege on all schemas
Date: Mon, 11 Sep 2023 18:42:56 -0700
Message-ID: <CAKFQuwZMV2njhUjugmmiy_i_=S0XXAYUojzA8oqRgbYnR7z+qw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

On Mon, Sep 11, 2023 at 6:05 PM <[email protected]> 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.

view thread (7+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Grant CREATE privilege on all schemas
  In-Reply-To: <CAKFQuwZMV2njhUjugmmiy_i_=S0XXAYUojzA8oqRgbYnR7z+qw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox