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