Re: Revoke delete on a table for super user

Поиск
Список
Период
Сортировка
От Ondřej Světlík
Тема Re: Revoke delete on a table for super user
Дата
Msg-id 997e138a-f05d-4f30-3bcc-85459ef7c898@flexibee.eu
обсуждение исходный текст
Ответ на Re: Revoke delete on a table for super user  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Revoke delete on a table for super user
Список pgsql-admin
Dne 2.8.2016 v 19:27 Tom Lane napsal(a):
> "Campbell, Lance" <lance@illinois.edu> writes:
>> Is there a way to revoke the ability to perform delete on a table for a user that is a super user?
>
> No.  Superusers bypass all access controls, by definition.  Your best bet
> is to not do more than you absolutely must as a superuser.
>
>             regards, tom lane
>
>

I guess you could achieve this using a trigger.

Regards,

Ondřej


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Revoke delete on a table for super user
Следующее
От: Bryan Ward
Дата:
Сообщение: Re: Revoke delete on a table for super user