On 15 January 2013 05:12, Tomonari Katsumata
<katsumata.tomonari@po.ntts.co.jp> wrote:
>> We added a REPLICATION privelge onto user accounts to control access.
>>
>> Perhaps we should add a CASCADE privilege as well, so that we can
>> control whether we can connect to a master and/or a standby.
>>
>> Syntax would be
>>
>> ALTER USER foo
>> [MASTER | CASCADE] REPLICATION
>>
>> REPLICATION allows both master and cascaded replication (same as now)
>> MASTER REPLICATION allows master only
>> CASCADE REPLICATION allows cascaded replication only
>> NOREPLICATION allows neither option
>>
> Someone is working for it already ?
> If not yet, may I try to implement it ?
Please do. It looks fairly short.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
