Re: allowing for control over SET ROLE
От
Alvaro Herrera
Тема
Re: allowing for control over SET ROLE
Дата
Msg-id
20221118184314.e4z3n5wzpcif5r52@alvherre.pgsql
Ответ на
Re: allowing for control over SET ROLE (Robert Haas)
Список
Дерево обсуждения
allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Nathan Bossart <nathandbossart@gmail.com>
Re: allowing for control over SET ROLE Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Jeff Davis <pgsql@j-davis.com>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Jeff Davis <pgsql@j-davis.com>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Nathan Bossart <nathandbossart@gmail.com>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Stephen Frost <sfrost@snowman.net>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE igor levshin <i.levshin@postgrespro.ru>
Re: allowing for control over SET ROLE Nathan Bossart <nathandbossart@gmail.com>
Re: allowing for control over SET ROLE Jeff Davis <pgsql@j-davis.com>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Jeff Davis <pgsql@j-davis.com>
Re: allowing for control over SET ROLE Noah Misch <noah@leadboat.com>
Re: allowing for control over SET ROLE Jeff Davis <pgsql@j-davis.com>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Jeff Davis <pgsql@j-davis.com>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Noah Misch <noah@leadboat.com>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Noah Misch <noah@leadboat.com>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Noah Misch <noah@leadboat.com>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Noah Misch <noah@leadboat.com>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Noah Misch <noah@leadboat.com>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Erik Rijkers <er@xs4all.nl>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Justin Pryzby <pryzby@telsasoft.com>
Re: allowing for control over SET ROLE Erik Rijkers <er@xs4all.nl>
Re: allowing for control over SET ROLE Michael Paquier <michael@paquier.xyz>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
Re: allowing for control over SET ROLE Michael Paquier <michael@paquier.xyz>
Re: allowing for control over SET ROLE Wolfgang Walther <walther@technowledgy.de>
Re: allowing for control over SET ROLE Robert Haas <robertmhaas@gmail.com>
On 2022-Nov-18, Robert Haas wrote:
> On Thu, Nov 17, 2022 at 7:24 PM Jeff Davis wrote:
> > But I'm fine if you'd like to move on with the SET ROLE privilege
> > instead, as long as we believe it grants a stable set of capabilities
> > (and conversely, that if the SET ROLE privilege is revoked, that it
> > revokes a stable set of capabilities).
>
> OK.
>
> Here's a rebased v3 to see what cfbot thinks.
I think this hunk in dumpRoleMembership() leaves an unwanted line
behind.
/*
- * Previous versions of PostgreSQL also did not have a grant-level
+ * Previous versions of PostgreSQL also did not have grant-level options.
* INHERIT option.
*/
(I was just looking at the doc part of this patch.)
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"El hombre nunca sabe de lo que es capaz hasta que lo intenta" (C. Dickens)
В списке pgsql-hackers по дате отправления