Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers)

Поиск
Список
Период
Сортировка
Искать
От
Mark Dilger
Тема
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers)
Дата
Msg-id
8A646633-0E51-470E-AB16-366AAA89B00F@enterprisedb.com
Ответ на
Список
Дерево обсуждения
Granting control of SUSET gucs to non-superusers Mark Dilger <mark.dilger@enterprisedb.com>
Re: Granting control of SUSET gucs to non-superusers Mark Dilger <mark.dilger@enterprisedb.com>
Re: Granting control of SUSET gucs to non-superusers Robert Haas <robertmhaas@gmail.com>
Re: Granting control of SUSET gucs to non-superusers Mark Dilger <mark.dilger@enterprisedb.com>
Re: Granting control of SUSET gucs to non-superusers Stephen Frost <sfrost@snowman.net>
Re: Granting control of SUSET gucs to non-superusers Mark Dilger <mark.dilger@enterprisedb.com>
Re: Granting control of SUSET gucs to non-superusers Jacob Champion <pchampion@vmware.com>
Re: Granting control of SUSET gucs to non-superusers Stephen Frost <sfrost@snowman.net>
Re: Granting control of SUSET gucs to non-superusers Mark Dilger <mark.dilger@enterprisedb.com>
Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Stephen Frost <sfrost@snowman.net>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Stephen Frost <sfrost@snowman.net>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Stephen Frost <sfrost@snowman.net>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Andrew Dunstan <andrew@dunslane.net>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Ronan Dunklau <ronan.dunklau@aiven.io>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) "Bossart, Nathan" <bossartn@amazon.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Stephen Frost <sfrost@snowman.net>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) "Bossart, Nathan" <bossartn@amazon.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Robert Haas <robertmhaas@gmail.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Stephen Frost <sfrost@snowman.net>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Robert Haas <robertmhaas@gmail.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Stephen Frost <sfrost@snowman.net>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Robert Haas <robertmhaas@gmail.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Stephen Frost <sfrost@snowman.net>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Isaac Morland <isaac.morland@gmail.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Stephen Frost <sfrost@snowman.net>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Robert Haas <robertmhaas@gmail.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Stephen Frost <sfrost@snowman.net>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Stephen Frost <sfrost@snowman.net>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Stephen Frost <sfrost@snowman.net>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Robert Haas <robertmhaas@gmail.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Robert Haas <robertmhaas@gmail.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Stephen Frost <sfrost@snowman.net>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Stephen Frost <sfrost@snowman.net>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Robert Haas <robertmhaas@gmail.com>
Re: Delegating superuser tasks to new security roles torikoshia <torikoshia@oss.nttdata.com>
Re: Delegating superuser tasks to new security roles Mark Dilger <mark.dilger@enterprisedb.com>
Re: Delegating superuser tasks to new security roles torikoshia <torikoshia@oss.nttdata.com>
Re: Granting control of SUSET gucs to non-superusers Chapman Flack <chap@anastigmatix.net>
Re: Granting control of SUSET gucs to non-superusers Michael Banck <michael.banck@credativ.de>
Re: Granting control of SUSET gucs to non-superusers Stephen Frost <sfrost@snowman.net>
Re: Granting control of SUSET gucs to non-superusers Tom Lane <tgl@sss.pgh.pa.us>
Re: Granting control of SUSET gucs to non-superusers Mark Dilger <mark.dilger@enterprisedb.com>
Re: Granting control of SUSET gucs to non-superusers Chapman Flack <chap@anastigmatix.net>
Re: Granting control of SUSET gucs to non-superusers Mark Dilger <mark.dilger@enterprisedb.com>
Re: Granting control of SUSET gucs to non-superusers Chapman Flack <chap@anastigmatix.net>
Re: Granting control of SUSET gucs to non-superusers Robert Haas <robertmhaas@gmail.com>
Re: Granting control of SUSET gucs to non-superusers Mark Dilger <mark.dilger@enterprisedb.com>
Re: Granting control of SUSET gucs to non-superusers Robert Haas <robertmhaas@gmail.com>
Re: Granting control of SUSET gucs to non-superusers Stephen Frost <sfrost@snowman.net>
Re: Granting control of SUSET gucs to non-superusers Tom Lane <tgl@sss.pgh.pa.us>
Re: Granting control of SUSET gucs to non-superusers Robert Haas <robertmhaas@gmail.com>
Re: Granting control of SUSET gucs to non-superusers Stephen Frost <sfrost@snowman.net>
Re: Granting control of SUSET gucs to non-superusers Robert Haas <robertmhaas@gmail.com>
Re: Granting control of SUSET gucs to non-superusers Chapman Flack <chap@anastigmatix.net>
Re: Granting control of SUSET gucs to non-superusers Robert Haas <robertmhaas@gmail.com>
Re: Granting control of SUSET gucs to non-superusers Chapman Flack <chap@anastigmatix.net>
Re: Granting control of SUSET gucs to non-superusers Isaac Morland <isaac.morland@gmail.com>


> On Oct 6, 2021, at 10:48 PM, Bharath Rupireddy  wrote:
> 
> Hi Mark, thanks for this work. I'm late to be here in this thread,
> please note that I didn't go through the entire thread as it is quite
> long for me to read.

Thanks for joining.

> I have a question: it looks like the view pg_backend_memory_contexts
> and the function pg_log_backend_memory_contexts are superuser only.
> Isn't it a good idea to allow users with a pg_monitor or some other
> similar role to use these as well? This question may be unrelated here
> but I'm curious to know whether your patch set has a solution.

Possibly, but I have stopped adding new topics to this particular patch set, as I'm already getting requests to break it into separate sets and email threads. 

—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company





В списке pgsql-hackers по дате отправления
От: Stephen Frost
Дата:
Сообщение: Re: storing an explicit nonce
От: Bruce Momjian
Дата:
Сообщение: Re: storing an explicit nonce
FAQ