Special role for subscriptions

From: Evgeniy Efimkin <efimkin(at)yandex-team(dot)ru>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Дмитрий Сарафанников <dsarafan(at)yandex-team(dot)ru>, Андрей Бородин <x4mmm(at)yandex-team(dot)ru>, Владимир Бородин <root(at)simply(dot)name>
Subject: Special role for subscriptions
Date: 2018-11-02 09:34:31
Message-ID: 1269681541151271@myt5-68ad52a76c91.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hi hackers!
In postgresql 10 and 11 only superuser can create/alter subscriptions.
If there was a special role (like pg_monitor), it would be more easy to grant control on subscriptions.
I can make a patch if there are no objections against it.


Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2018-11-02 09:50:12 Re: Resetting PGPROC atomics in ProcessInit()
Previous Message Masahiko Sawada 2018-11-02 09:26:02 Re: [HACKERS] Block level parallel vacuum