On Wed, May 22, 2024 at 1:58 PM Tom Lane <t...@sss.pgh.pa.us> wrote:
> Ron Johnson <ronljohnso...@gmail.com> writes: > > That would be a helpful feature for administrators, when there are > multiple > > schemas in multiple databases, on multiple servers: superusers get ALTER > > ROLE foo SET SEARCH_PATH = '*'; and they're done with it. > > ... and they're pwned within five minutes by any user with the wits > to create a trojan-horse function or operator. Generally speaking, > you want admins to run with a minimal search path not a maximal one. > Missing tables when running "\t" is a bigger hassle.