Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sggeA-006Bkj-WC for pgsql-general@arkaria.postgresql.org; Wed, 21 Aug 2024 08:24:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sgge8-008FNE-FU for pgsql-general@arkaria.postgresql.org; Wed, 21 Aug 2024 08:24:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sgge7-008FN6-Ve for pgsql-general@lists.postgresql.org; Wed, 21 Aug 2024 08:24:48 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sgge4-000kNn-99 for pgsql-general@lists.postgresql.org; Wed, 21 Aug 2024 08:24:47 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mx2023; t=1724228684; bh=aNemOsuQhvSplB6Bmvxt7fWq9jhB4GrnF8ZWv+5x/EI=; h=Message-ID:Date:User-Agent:Subject:From:To:References:In-Reply-To: From; b=E3wOTZ0v9B/6WAtCuWFA/iwx73JsjkOASSx1nK7nq1hUk2IjKTZ7xN5MZpF0+55lU KIz4TWKM8FokMFTAYRtzkvX/fMPBSXPDAkARL6h3kbJFlok5gyVA9gmPkVOklugzEn 5IbuTxTjagXPiu4TRMKJMfcE39i79tOoYsh/jPoot3RUAYV3VcGrJKttM/brWcVSlR z1goOSqXrTEictWruYlKoSue6EZoX2KTbTb1lLD2CPfCdzz4IAlkI+xJHdMnSYHen2 SL5R68d4l4ODbBo+Tx83u5wvKzGn4+X1sjXMPgO//LeQeo55XVPsqZlrlnxwInt1YC baN2bzBos69kA== Received: from [192.168.0.104] (unknown [62.217.185.30]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (Client did not present a certificate) (Authenticated sender: p.luzanov@postgrespro.ru) by mail.postgrespro.ru (Postfix/587) with ESMTPSA id EC34360139; Wed, 21 Aug 2024 11:24:43 +0300 (MSK) Content-Type: multipart/alternative; boundary="------------68USjKmTNliPPc86TYgbIYi3" Message-ID: Date: Wed, 21 Aug 2024 11:24:43 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: insufficient privilege with pg_read_all_stats granted From: Pavel Luzanov To: Costa Alexoglou , pgsql-general@lists.postgresql.org References: Content-Language: en-US, ru-RU In-Reply-To: X-KSMG-AntiPhishing: NotDetected, bases: 2024/08/21 05:09:00 X-KSMG-AntiSpam-Interceptor-Info: not scanned X-KSMG-AntiSpam-Status: not scanned, disabled by settings X-KSMG-AntiVirus: Kaspersky Secure Mail Gateway, version 2.1.0.7854, bases: 2024/08/21 06:50:00 #26388227 X-KSMG-AntiVirus-Status: NotDetected, skipped X-KSMG-LinksScanning: not scanned, disabled by settings X-KSMG-Message-Action: skipped X-KSMG-Rule-ID: 1 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------68USjKmTNliPPc86TYgbIYi3 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 21.08.2024 10:50, Pavel Luzanov wrote: > But I don't understand why it worked in v14. > Probablysomethinghas changed, butIcouldn't quicklyfindwhatexactly. Ifoundit. https://github.com/postgres/postgres/commit/6198420a -- Pavel Luzanov Postgres Professional:https://postgrespro.com --------------68USjKmTNliPPc86TYgbIYi3 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit On 21.08.2024 10:50, Pavel Luzanov wrote:
But I don't understand why it worked in v14.
Probably something has changed, but I couldn't quickly find what exactly.
I found it.
https://github.com/postgres/postgres/commit/6198420a
-- 
Pavel Luzanov
Postgres Professional: https://postgrespro.com
--------------68USjKmTNliPPc86TYgbIYi3--