Re: Remove default privilege from DB

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Remove default privilege from DB
Дата
Msg-id CAKFQuwZua8+4ww+HJ1kTUw=ZSBxrsFxoKauxVGhwWRKtDgVouA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Remove default privilege from DB  (Durumdara <durumdara@gmail.com>)
Ответы Re: Remove default privilege from DB  (Stephen Frost <sfrost@snowman.net>)
Список 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 по дате отправления:

Предыдущее
От: Durumdara
Дата:
Сообщение: Re: Remove default privilege from DB
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Remove default privilege from DB