Revoke "drop database" even for superusers?

From: Edson Richter <richter(at)simkorp(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Revoke "drop database" even for superusers?
Date: 2012-11-09 11:19:58
Message-ID: 509CE6DE.50906@simkorp.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2012-11-09 11:42:37 Re: Revoke "drop database" even for superusers?
Previous Message Achilleas Mantzios 2012-11-09 10:17:14 Re: Memory issue on FreeBSD