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

From Euler Taveira
Subject Re: Special role for subscriptions
Date
Msg-id CAHE3wgi2qjj6asu-Udy4+DNt5eoKE+gUZNQYm0U08JLKxt8yBw@mail.gmail.com
Whole thread Raw
In response to Re: Special role for subscriptions  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Special role for subscriptions
List pgsql-hackers
Em qua, 20 de mar de 2019 às 21:57, Michael Paquier
<michael@paquier.xyz> escreveu:
>
> Perhaps we would want something at database level different from GRANT
> CREATE ON DATABASE, but only for subscriptions?  This way, it is
> possible to have per-database groups having the right to create
> subscriptions, and I'd like to think that we should not include
> subcription creation into the existing CREATE rights.  It would be
> kind of funny to not have CREATE include the creation of this specific
> object though :)
>
It will be really strange but I can live with that. Another idea is
CREATE bit to create subscriptions (without replicate) and SUBSCRIBE
bit to replicate tables. It is not just a privilege to create a
subscription but also to modify tables that a role doesn't have
explicit permission. Let's allocate another AclItem?


--
   Euler Taveira                                   Timbira -
http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento


pgsql-hackers by date:

Previous
From: Jesper Pedersen
Date:
Subject: Re: speeding up planning with partitions
Next
From: Jeremy Finzel
Date:
Subject: Re: Automated way to find actual COMMIT LSN of subxact LSN