Revoke "drop database" even for superusers?

Поиск
Список
Период
Сортировка
От Edson Richter
Тема Revoke "drop database" even for superusers?
Дата
Msg-id 509CE6DE.50906@simkorp.com.br
обсуждение исходный текст
Ответы 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>)
Список 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

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Memory issue on FreeBSD
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Revoke "drop database" even for superusers?