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
On 05/06/2019 09:52, Laurenz Albe wrote:
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.
T
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.
This function can be called by a normal
Hi All,
Is there any way to grant rights to a user such that they can drop and
re-create only a single database?
cheers,
Chris
