MIME-Version: 1.0
References: <162149110071.26171.15811576640435665698@wrigleys.postgresql.org>
 <YKYJDXxnQ4hcUVYd@paquier.xyz>
In-Reply-To: <YKYJDXxnQ4hcUVYd@paquier.xyz>
From: Julien Rouhaud <rjuju123@gmail.com>
Date: Thu, 20 May 2021 16:54:27 +0800
Message-ID: 
 <CAOBaU_Y3b1Vet2UPDwjyi-pVv1wxT8fH4Fe4UKEZbZi6C-SGWQ@mail.gmail.com>
Subject: Re: pg_monitor role description
To: Michael Paquier <michael@paquier.xyz>
Cc: pluzanov@postgrespro.ru, pgsql-docs@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Archived-At: 
 <https://www.postgresql.org/message-id/CAOBaU_Y3b1Vet2UPDwjyi-pVv1wxT8fH4Fe4UKEZbZi6C-SGWQ%40mail.gmail.com>
Precedence: bulk

On Thu, May 20, 2021 at 3:01 PM Michael Paquier <michael@paquier.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.