Re: pg_monitor role description

On 20.05.2021 11:54, Julien Rouhaud wrote:

> On Thu, May 20, 2021 at 3:01 PM Michael Paquier <michael(at)paquier(dot)xyz> wrote:
>> On Thu, May 20, 2021 at 06:11:40AM +0000, PG Doc comments form wrote:
>>> "This role is a member of pg_read_all_settings, pg_read_all_stats and
>>> pg_stat_scan_tables."
>>> Is it correct sentence?
>>> It seems for me that pg_read_all_stats is a member of pg_monitor. But not
>>> vice versa.
>> Here is what I am getting:
>> =# \dgS pg_monitor
>> List of roles
>> Role name | Attributes | Member of
>> ------------+--------------+--------------------------------------------------------------
>> pg_monitor | Cannot login | {pg_read_all_settings,pg_read_all_stats,pg_stat_scan_tables}
>>
>> =# \dgS pg_read_all_data
>> List of roles
>>
>> Role name | Attributes | Member of
>> ------------------+--------------+-----------
>> pg_read_all_data | Cannot login | {}
>>
>> So the docs look correct to me.
> Indeed. In other words pg_monitor is the sum of the authorizations
> given by all those roles.

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. And column header in a \du output must be something like 'members' instead of 'member of'.

--
Pavel Luzanov
Postgres Professional: https://postgrespro.com
The Russian Postgres Company