From: Tom Lane <tgl@sss.pgh.pa.us>
To: Pavel Luzanov <p.luzanov@postgrespro.ru>
cc: Julien Rouhaud <rjuju123@gmail.com>,
 Michael Paquier <michael@paquier.xyz>,
        pluzanov@postgrespro.ru, pgsql-docs@lists.postgresql.org
Subject: Re: pg_monitor role description
In-reply-to: <7018bb3a-26f1-a9be-1659-3bdafd122669@postgrespro.ru>
References: <162149110071.26171.15811576640435665698@wrigleys.postgresql.org>
 <YKYJDXxnQ4hcUVYd@paquier.xyz>
 <CAOBaU_Y3b1Vet2UPDwjyi-pVv1wxT8fH4Fe4UKEZbZi6C-SGWQ@mail.gmail.com>
 <7018bb3a-26f1-a9be-1659-3bdafd122669@postgrespro.ru>
Comments: In-reply-to Pavel Luzanov <p.luzanov@postgrespro.ru>
	message dated "Thu, 20 May 2021 15:44:52 +0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3690477.1621526623.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 20 May 2021 12:03:43 -0400
Message-ID: <3690478.1621526623@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3690478.1621526623%40sss.pgh.pa.us>
Precedence: bulk

Pavel Luzanov <p.luzanov@postgrespro.ru> writes:
> Let me try one more time.
> What is correct from the English language point of view:
> 1. Julien Rouhaud is a member of PostgreSQL Community.
> or
> 2. PostgreSQL Community is a member of Julien Rouhaud, Michael Paquier.
> Or both forms are correct?
> I think that 1 is correct.

You're right about that ...

> And column header in a \du output must be something like 'members' inste=
ad of 'member of'.

... but this does not follow, because it's a poor analogy.  "Member of"
means "these role(s) have been GRANT'ed to pg_monitor".

As a more typical use-case, there might be a role "sysadmins" that holds
assorted privileges, and then certain individual users are granted that
role.  Nobody would quibble with seeing

             List of roles
 Role name |  Attributes  |  Member of  =

-----------+--------------+-------------
 bob       |              | {sysadmins}
 joe       |              | {sysadmins}
 sysadmins | Cannot login | {}

and I think most would agree that titling the column "Members" would
be backwards.

			regards, tom lane