Re: docs: mention "pg_read_all_stats" in "track_activities" description - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: docs: mention "pg_read_all_stats" in "track_activities" description
Date
Msg-id Yo2qtFNyJUe1rgF5@paquier.xyz
Whole thread Raw
In response to Re: docs: mention "pg_read_all_stats" in "track_activities" description  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: docs: mention "pg_read_all_stats" in "track_activities" description  (Michael Paquier <michael@paquier.xyz>)
List 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

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Tab-complete for CREATE EVENT TRIGGER ON TABLE_REWRITE
Next
From: Amit Langote
Date:
Subject: Re: First draft of the PG 15 release notes