Re: docs: mention "pg_read_all_stats" in "track_activities" description

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc: Ian Lawrence Barwick <barwick(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: docs: mention "pg_read_all_stats" in "track_activities" description
Date: 2022-05-25 04:04:04
Message-ID: Yo2qtFNyJUe1rgF5@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, May 23, 2022 at 09:41:42AM -0700, Nathan Bossart wrote:
> I think we need to be careful about saying "member of" when we really mean
> "roles with privileges of." Unless I am mistaken, role membership alone is
> not sufficient for viewing this information. You also need to inherit the
> role's privileges via INHERIT.

Good point. So this would give, to be exact:
"This information is only visible to superusers, roles with privileges
of the pg_read_all_stats role, and and the user owning the sessionS
being reported on (including sessions belonging to a role they have
the privileges of)."

Opinions?
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2022-05-25 04:04:31 Re: First draft of the PG 15 release notes
Previous Message Michael Paquier 2022-05-25 03:56:50 Re: Tab-complete for CREATE EVENT TRIGGER ON TABLE_REWRITE