Re: Alter default privileges is not working for roles

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Alter default privileges is not working for roles
Дата
Msg-id CAKFQuwbdbeRauJwo6RMS1aBq5yVnUAbwOQQs7B=n89RKTLbD9w@mail.gmail.com
обсуждение исходный текст
Ответ на Alter default privileges is not working for roles  (Teju Jakkidi vlogs <teja.jakkidi05@gmail.com>)
Ответы Re: Alter default privileges is not working for roles  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
On Wed, Feb 22, 2023 at 10:53 AM Teju Jakkidi vlogs <teja.jakkidi05@gmail.com> wrote:

alter default privileges for role ownerrole

Now our expectation is that if there is any table created by any user

The specification of "ownerrole" in that command means that said default privileges only are created if "ownerrole" is the one creating the objects - not "created by any user".

David J.

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

Предыдущее
От: Teju Jakkidi vlogs
Дата:
Сообщение: Alter default privileges is not working for roles
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Alter default privileges is not working for roles