Revoke "drop database" even for superusers? - Mailing list pgsql-general

From Edson Richter
Subject Revoke "drop database" even for superusers?
Date
Msg-id 509CE6DE.50906@simkorp.com.br
Whole thread Raw
Responses Re: Revoke "drop database" even for superusers?  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Re: Revoke "drop database" even for superusers?  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-general
I've a bunch of databases that cannot be dropped in any case.

I was wondering if it is possible to revoke "drop database" permission for all users, in order that even superuser, if he wishes to drop a database, he will need first to "grant drop database" first.

I know there is already a safety that does not allow dropping databases in use - I just want to make even harder.

Regards,
--

Edson Carlos Ericksson Richter
SimKorp Informática Ltda
Fone:(51) 3366-7964
Celular:(51)9318-9766/(51) 8585-0796
Embedded Image

Attachment

pgsql-general by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: Memory issue on FreeBSD
Next
From: "Albe Laurenz"
Date:
Subject: Re: Revoke "drop database" even for superusers?