On 1/26/17 1:25 PM, Simon Riggs wrote:
> That should include the ability to dump all objects, yet without any
> security details. And it should allow someone to setup logical
> replication easily, including both trigger based and new logical
> replication. And GRANT ON ALL should work.
This basically sounds like a GRANT $privilege ON ALL $objecttype TO
$user. So you could have a user that can read everything, for example.
This kind of thing has been asked for many times, but that quieted down
when the default privileges feature appeared. I think it would still be
useful.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services