From: "Pavlo Golub" <pavlo.golub@cybertec.at>
To: "Nathan Bossart" <nathandbossart@gmail.com>
Subject: Re[2]: [PATCH] allow pg_current_logfile() execution under pg_monitor role
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: Mon, 12 Feb 2024 12:27:54 +0000
Message-Id: <em6ad775cd-5e48-497f-9708-46f201400f23@52f0f93e.com>
In-Reply-To: <20240209163657.GC663211@nathanxps13>
References: <CAK7ymcLmEYWyQkiCZ64WC-HCzXAB0omM=Ypj9B3rXe8vUAFMqw@mail.gmail.com>
 <20240209163657.GC663211@nathanxps13>
Reply-To: "Pavlo Golub" <pavlo.golub@cybertec.at>
User-Agent: eM_Client/9.2.2157.0
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------=_MB12310FB7-AC8A-4B41-8566-B58BBB73FEA3"
Archived-At: <https://www.postgresql.org/message-id/em6ad775cd-5e48-497f-9708-46f201400f23%4052f0f93e.com>
Precedence: bulk

--------=_MB12310FB7-AC8A-4B41-8566-B58BBB73FEA3
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: quoted-printable

>  Are there any other
>functions that pg_monitor ought to have privileges for?
>
Not that I'm aware of at the moment. This one was found by chance.

Kind regards,
Pavlo Golub
--------=_MB12310FB7-AC8A-4B41-8566-B58BBB73FEA3
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head>

<style id=3D"css_styles" type=3D"text/css">blockquote.cite { margin-left: 5=
px; margin-right: 0px; padding-left: 10px; padding-right:0px; border-left:=
 1px solid #cccccc }
blockquote.cite2 {margin-left: 5px; margin-right: 0px; padding-left: 10px;=
 padding-right:0px; border-left: 1px solid #cccccc; margin-top: 3px; padding=
-top: 0px; }
a img { border: 0px; }
li[style=3D'text-align: center;'], li[style=3D'text-align: center; '], li[s=
tyle=3D'text-align: right;'], li[style=3D'text-align: right; '] {  list-sty=
le-position: inside;}
body { font-family: 'Segoe UI'; font-size: 12pt; }
.quote { margin-left: 1em; margin-right: 1em; border-left: 5px #ebebeb soli=
d; padding-left: 0.3em; }
<!--blockquote.cite { margin-left: 5px; margin-right: 0px; padding-left: 10=
px; padding-right:0px; border-left: 1px solid #cccccc }
blockquote.cite2 {margin-left: 5px; margin-right: 0px; padding-left: 10px;=
 padding-right:0px; border-left: 1px solid #cccccc; margin-top: 3px; padding=
-top: 0px; }
a img { border: 0px; }
li[style=3D'text-align: center;'], li[style=3D'text-align: center; '], li[s=
tyle=3D'text-align: right;'], li[style=3D'text-align: right; '] {  list-sty=
le-position: inside;}
body { font-family: 'Segoe UI'; font-size: 12pt; }
.quote { margin-left: 1em; margin-right: 1em; border-left: 5px #ebebeb soli=
d; padding-left: 0.3em; }
--></style></head><body><div id=3D"x4e9692ad92f44de"><blockquote type=3D"ci=
te" class=3D"cite2"><div class=3D"plain_line"> Are there any other</div>
<div class=3D"plain_line">functions that pg_monitor ought to have privilege=
s for?</div>
<div class=3D"plain_line"><br /></div></blockquote><span>Not that I'm aware =
of at the moment. This one was found by chance.</span></div><div id=3D"x4e=
9692ad92f44de"><br /></div><div id=3D"x4e9692ad92f44de">Kind regards,</div>=
<div id=3D"x4e9692ad92f44de">Pavlo Golub</div>
</body></html>
--------=_MB12310FB7-AC8A-4B41-8566-B58BBB73FEA3--