Re: pgsql: Allow GRANT on pg_log_backend_memory_contexts().

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Jeff Davis <jdavis(at)postgresql(dot)org>
Cc: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Allow GRANT on pg_log_backend_memory_contexts().
Date: 2021-10-27 04:15:46
Message-ID: YXjScrEwVMW69rSF@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

On Tue, Oct 26, 2021 at 08:41:11PM +0000, Jeff Davis wrote:
> Allow GRANT on pg_log_backend_memory_contexts().
>
> Remove superuser check, allowing any user granted permissions on
> pg_log_backend_memory_contexts() to log the memory contexts of any
> backend.
>
> Note that this could allow a privileged non-superuser to log the
> memory contexts of a superuser backend, but as discussed, that does
> not seem to be a problem.

but will not be sent to the client regardless of
<xref linkend="guc-client-min-messages"/>.
- Only superusers can request to log the memory contexts.
</para></entry>
I don't think that the documentation part of this commit is correct.
This sentence should have been changed to something like the
following:
"This function is restricted to superusers by default, but other users
can be granted EXECUTE to run the function."

Thanks,
--
Michael

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Bharath Rupireddy 2021-10-27 04:57:18 Re: pgsql: Allow GRANT on pg_log_backend_memory_contexts().
Previous Message Amit Kapila 2021-10-27 02:26:55 pgsql: Allow publishing the tables of schema.