| From: | Evgeniy Efimkin <efimkin(at)yandex-team(dot)ru> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz> |
| Cc: | Jeff Davis <pgsql(at)j-davis(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Дмитрий Сарафанников <dsarafan(at)yandex-team(dot)ru>, Андрей Бородин <x4mmm(at)yandex-team(dot)ru>, Владимир Бородин <root(at)simply(dot)name> |
| Subject: | Re: Special role for subscriptions |
| Date: | 2019-03-13 14:55:56 |
| Message-ID: | 33431552488956@vla1-9d3c37294942.qloud-c.yandex.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi!
Thanks for comments!
> Just letting the superuser decide who gets to create subscriptions
> seems good enough from here.
I've prepare patch with new system role, i'm not sure about name, called it "pg_subscription_users".
In that patch we don't check permissions on target tables, i don't know, should we check it?
--------
Efimkin Evgeny
| Attachment | Content-Type | Size |
|---|---|---|
| pg_subscription_role_v1.patch | text/x-diff | 11.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-03-13 15:00:17 | Re: using index or check in ALTER TABLE SET NOT NULL |
| Previous Message | Lætitia Avrot | 2019-03-13 14:33:52 | Re: [Patch] Log10 and hyperbolic functions for SQL:2016 compliance |