Re: [HACKERS] Superowners

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: [HACKERS] Superowners
Дата
Msg-id 20170130004445.GQ9812@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: [HACKERS] Superowners  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы Re: [HACKERS] Superowners  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Re: [HACKERS] Superowners  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers
* Peter Eisentraut (peter.eisentraut@2ndquadrant.com) wrote:
> 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.

Agreed.  I would think we'd either do this with a default role or a role
attribute.

Thanks!

Stephen

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] [PATCH] Rename pg_switch_xlog to pg_switch_wal
Следующее
От: vinayak
Дата:
Сообщение: Re: [HACKERS] Transactions involving multiple postgres foreignservers