Re: allowing for control over SET ROLE

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: allowing for control over SET ROLE
Дата
Msg-id
20221118184314.e4z3n5wzpcif5r52@alvherre.pgsql
Ответ на
Список
Дерево обсуждения
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 по дате отправления
От: Thomas Munro
Дата:
От: Robert Haas
Дата:
FAQ