Postgres Pro
Downloads
Home   >   mailing lists

Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE - Mailing list pgsql-general

From Pavel Luzanov
Subject Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE
Date
Msg-id 2e3e4ddb-52b5-49b2-b363-00e3f12a83a0@postgrespro.ru
Whole thread Raw
In response to v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE  (Christophe Pettus <xof@thebuild.com>)
Responses Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE
Next
From: Tom Lane
Date:
Subject: Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE