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

From Evgeniy Efimkin
Subject Re: Special role for subscriptions
Date
Msg-id 112671553163718@myt5-68ad52a76c91.qloud-c.yandex.net
Whole thread Raw
In response to Re: Special role for subscriptions  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
Hi!

> Perhaps we would want something at database level different from GRANT
> CREATE ON DATABASE, but only for subscriptions?
How about 4 checks to create subscription for nonsuperuser?
1. Special role for create subscription 
2. CREATE ON DATABASE privilege 
3. INSERT, UPDATE, DELETE, TRUNCATE, REFERENCE privilege on target table
4. target table not in information_schema and pg_catalog

-------- 
Efimkin Evgeny



pgsql-hackers by date:

Previous
From: Evgeniy Efimkin
Date:
Subject: Re: Special role for subscriptions
Next
From: Sergei Kornilov
Date:
Subject: Re: [HACKERS] Block level parallel vacuum