Re: Remove default privilege from DB - Mailing list pgsql-general

From David G. Johnston
Subject Re: Remove default privilege from DB
Date
Msg-id CAKFQuwZua8+4ww+HJ1kTUw=ZSBxrsFxoKauxVGhwWRKtDgVouA@mail.gmail.com
Whole thread Raw
In response to Re: Remove default privilege from DB  (Durumdara <durumdara@gmail.com>)
Responses Re: Remove default privilege from DB  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
On Fri, Feb 16, 2018 at 7:56 AM, Durumdara <durumdara@gmail.com> wrote:
I want to know what happened in the background.
I will make "negative" state if I revoke DefACL without prior grant?

​Not really following the whole thread but figured I'm comment on this point that confused me in the past as well.​

​Not sure if this is what you mean but there is no concept of "negative state" in the permissions system.  Everything starts out with no permissions.  Grant adds permissions and revoke un-adds granted permissions.​  Revoking something that doesn't exist is either a no-op or a warning depending on the context - either way its doesn't setup a "forbidden" state for the permission.

Revoking/granting on default ACLs never affects already existing objects.

David J.

pgsql-general by date:

Previous
From: Durumdara
Date:
Subject: Re: Remove default privilege from DB
Next
From: Stephen Frost
Date:
Subject: Re: Remove default privilege from DB