Re: Special role for subscriptions - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: Special role for subscriptions
Date
Msg-id E79B8828-6291-476D-82C1-577005D7B513@yandex-team.ru
Whole thread Raw
In response to Re: Special role for subscriptions  (Evgeniy Efimkin <efimkin@yandex-team.ru>)
Responses Re: Special role for subscriptions
List pgsql-hackers
Hi!

> 13 марта 2019 г., в 22:55, Evgeniy Efimkin <efimkin@yandex-team.ru> написал(а):
>
> 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?

Currently, user with pg_subscription_users can create subscription into any system table, can't they?
We certainly need to change it to more secure way.

Best regards, Andrey Borodin.

pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: [survey] New "Stable" QueryId based on normalized query text
Next
From: "Wu, Fei"
Date:
Subject: RE: Willing to fix a PQexec() in libpq module