Chris Withers wrote:
> > > Is there any way to grant rights to a user such that they can drop and
> > > re-create only a single database?
> > No; what I'd do if I needed that is to create a SECURITY DEFINER function
> > that is owned by a user with the CREATEDB privilege.
>
> Thanks, that's a great idea! Is this pattern documented anywhere as a
> complete finished thing?
I'm afraid that is left as an exercise to the reader.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com