Re: Special role for subscriptions

Поиск
Список
Период
Сортировка
От Evgeniy Efimkin
Тема Re: Special role for subscriptions
Дата
Msg-id 144481553074787@vla1-9d3c37294942.qloud-c.yandex.net
обсуждение исходный текст
Ответ на Re: Special role for subscriptions  (Andrey Borodin <x4mmm@yandex-team.ru>)
Ответы Re: Special role for subscriptions
Список pgsql-hackers

Hi!
> 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.
No, you can't add system tables to publication. In new patch i add privileges checks on target table, non superuser
can'tcreate/refresh subscription if he don't have INSERT, UPDATE, DELETE and TRUNCATE privileges.
 


-------- 
Efimkin Evgeny

Вложения

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