Re: debugger from superuser only.... why? - Mailing list pgsql-general

From Alexander Petrossian
Subject Re: debugger from superuser only.... why?
Date
Msg-id 938407CE-46E9-4699-AB0C-DB02F2755B2A@gmail.com
Whole thread Raw
In response to Re: debugger from superuser only.... why?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: debugger from superuser only.... why?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: debugger from superuser only.... why?  (Luca Ferrari <fluca1978@gmail.com>)
List pgsql-general
> 25 сент. 2023 г., в 17:28, Tom Lane <tgl@sss.pgh.pa.us> написал(а):
> Alexander Petrossian <alexander.petrossian@gmail.com> writes:
>>>> I am wondering why is this, why not allow debugging for non-privileged users?
> Even if there's a way to restrict
> debugging connections to sessions owned by the same user,

I guess, there is such a way. Looks trivial...

> you’d have a big problem with being able to change the behavior of
> security-definer functions.

Could you please elaborate on this, Tom?

My worry is that it is very inconvenient.
And if reasons are not super-solid, maybe one can budge the Author? :)

>  Clearly, the authors of pldebugger
> decided that was a can of worms they didn't care to open.

Unless one wants to go fishing ;)

PAF


pgsql-general by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: Regarding PostgreSQL 15.4
Next
From: Tom Lane
Date:
Subject: Re: debugger from superuser only.... why?