On Mon, Jul 8, 2024 at 12:23 PM Christophe Pettus <xof(at)thebuild(dot)com> 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?
>
>
That scenario is allowed but provides no useful in-server behavior. I
suppose the membership presence/absence could be given external meaning by
a DBA. Personally, I'd just add a metric on the server counting these and
alert if it is ever non-zero.
David J.