Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Revoke delete on a table for super user
Date
Msg-id 18971.1470158828@sss.pgh.pa.us
Whole thread Raw
In response to Revoke delete on a table for super user  ("Campbell, Lance" <lance@illinois.edu>)
Responses Re: Revoke delete on a table for super user
List pgsql-admin
Tree view 
"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

pgsql-admin by date:

Previous
From: "Campbell, Lance"
Date:
Subject: Revoke delete on a table for super user
Next
From: Ondřej Světlík
Date:
Subject: Re: Revoke delete on a table for super user