Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE

From: Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>
To: Christophe Pettus <xof(at)thebuild(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE
Date: 2024-07-08 21:00:35
Message-ID: 2e3e4ddb-52b5-49b2-b363-00e3f12a83a0@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 08.07.2024 22:22, Christophe Pettus wrote:
> This is more curiosity than anything else. In the v16 role system, is there actually any reason to grant membership in a role to a different role, but with SET FALSE, INHERIT FALSE, and ADMIN FALSE? Does the role granted membership gain any ability it didn't have before in that case?

Looks like there is one ability.
Authentication in pg_hba.conf "USER" field via +role syntax.

--
Pavel Luzanov
Postgres Professional:https://postgrespro.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2024-07-08 21:16:28 Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE
Previous Message David G. Johnston 2024-07-08 20:42:38 Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE