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 1qlUxc-0034Ge-CN for pgsql-general@arkaria.postgresql.org; Wed, 27 Sep 2023 13:52:16 +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 1qlUxb-004YDP-1O for pgsql-general@arkaria.postgresql.org; Wed, 27 Sep 2023 13:52:15 +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 1qlUxa-004YDG-Ll for pgsql-general@lists.postgresql.org; Wed, 27 Sep 2023 13:52:14 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qlUxX-007tqw-T8 for pgsql-general@lists.postgresql.org; Wed, 27 Sep 2023 13:52:14 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 38RDq9Gh598115; Wed, 27 Sep 2023 09:52:09 -0400 From: Tom Lane To: Alexander Petrossian cc: Luca Ferrari , =?utf-8?B?0JDQu9C10LrRgdCw0L3QtNGAINCf0LXRgtGA0L7RgdGP0L0=?= , "pgsql-general@lists.postgresql.org" Subject: Re: debugger from superuser only.... why? In-reply-to: <938407CE-46E9-4699-AB0C-DB02F2755B2A@gmail.com> References: <6006191695187640@mail.yandex.ru> <086C5BA0-7B8F-42EE-ABEC-3EF403D1599B@gmail.com> <170505.1695652114@sss.pgh.pa.us> <938407CE-46E9-4699-AB0C-DB02F2755B2A@gmail.com> Comments: In-reply-to Alexander Petrossian message dated "Wed, 27 Sep 2023 14:30:43 +0300" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <598113.1695822729.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Wed, 27 Sep 2023 09:52:09 -0400 Message-ID: <598114.1695822729@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Alexander Petrossian writes: > 25 =D1=81=D0=B5=D0=BD=D1=82. 2023 =D0=B3., =D0=B2 17:28, Tom Lane =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0): >> you=E2=80=99d have a big problem with being able to change the behavior= of >> security-definer functions. > Could you please elaborate on this, Tom? pldebugger allows you to change the contents of a function's local variables. Obviously the threat level would depend a lot on the details of the particular function, but it's not hard to envision cases where that would be enough to make the function do something other than what it was supposed to. regards, tom lane