Re: Revoke delete on a table for super user - Mailing list pgsql-admin

From Ondřej Světlík
Subject Re: Revoke delete on a table for super user
Date
Msg-id 997e138a-f05d-4f30-3bcc-85459ef7c898@flexibee.eu
Whole thread Raw
In response to Re: Revoke delete on a table for super user  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Revoke delete on a table for super user
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Revoke delete on a table for super user
Next
From: Bryan Ward
Date:
Subject: Re: Revoke delete on a table for super user