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
Ответ на
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) (Bharath Rupireddy)
Список
Дерево обсуждения
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) Noah Misch <noah@leadboat.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) 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) 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) Jeff Davis <pgsql@j-davis.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) Jeff Davis <pgsql@j-davis.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) Jeff Davis <pgsql@j-davis.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) Jeff Davis <pgsql@j-davis.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) Jeff Davis <pgsql@j-davis.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) 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) 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) 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) 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) Tom Lane <tgl@sss.pgh.pa.us>
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) Stephen Frost <sfrost@snowman.net>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Tom Lane <tgl@sss.pgh.pa.us>
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) Tom Lane <tgl@sss.pgh.pa.us>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Tom Lane <tgl@sss.pgh.pa.us>
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) Isaac Morland <isaac.morland@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) Tom Lane <tgl@sss.pgh.pa.us>
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) 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) vignesh C <vignesh21@gmail.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Andrey Borodin <x4mmm@yandex-team.ru>
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) 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) Robert Haas <robertmhaas@gmail.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Jeff Davis <pgsql@j-davis.com>
Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) Noah Misch <noah@leadboat.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) Jeff Davis <pgsql@j-davis.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) Jeff Davis <pgsql@j-davis.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 по дате отправления