MIME-Version: 1.0
References: <CANzqJaDxVFRPreSz_e=cg2PU2nW48BUcoJTyvc72Yry0tqkTcQ@mail.gmail.com>
 <CAKFQuwZx0G=0fPDmhwWiCNT1+ZUWYQGkYVj5Vab10A0_bksq0g@mail.gmail.com> <CANzqJaCjWr3Z3typ-Ye8vitiiYQEkCGz=w4Sx9Up7dZ+Hsb6Fw@mail.gmail.com>
In-Reply-To: <CANzqJaCjWr3Z3typ-Ye8vitiiYQEkCGz=w4Sx9Up7dZ+Hsb6Fw@mail.gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Wed, 22 May 2024 21:34:39 +0200
Message-ID: <CAFj8pRDg0UGkG9=LVRL2-mmJRTK2_KkEuzvzgBRqVDP2LZiR_A@mail.gmail.com>
Subject: Re: search_path wildcard?
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000aebc23061910085b"
Archived-At: <https://www.postgresql.org/message-id/CAFj8pRDg0UGkG9%3DLVRL2-mmJRTK2_KkEuzvzgBRqVDP2LZiR_A%40mail.gmail.com>
Precedence: bulk

--000000000000aebc23061910085b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

st 22. 5. 2024 v 19:54 odes=C3=ADlatel Ron Johnson <ronljohnsonjr@gmail.com=
>
napsal:

> On Wed, May 22, 2024 at 12:53=E2=80=AFPM David G. Johnston <
> david.g.johnston@gmail.com> wrote:
>
>> On Wed, May 22, 2024, 10:36 Ron Johnson <ronljohnsonjr@gmail.com> wrote:
>>
>>> This doesn't work, and I've found nothing similar:
>>> ALTER ROLE foo SET SEARCH_PATH  =3D '*';
>>>
>>
>> Correct, you cannot do that.
>>
>
> That would be a helpful feature for administrators, when there are
> multiple schemas in multiple databases, on multiple servers: superusers g=
et ALTER
> ROLE foo SET SEARCH_PATH  =3D '*'; and they're done with it.
>

It can be pretty dangerous, because you don't specify order of schemas

Regards

Pavel

--000000000000aebc23061910085b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">st 22. 5. 2024 v=C2=A019:54 odes=C3=
=ADlatel Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com">ronljoh=
nsonjr@gmail.com</a>&gt; napsal:<br></div><blockquote class=3D"gmail_quote"=
 style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);p=
adding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Wed, May 22, 2024 at =
12:53=E2=80=AFPM David G. Johnston &lt;<a href=3D"mailto:david.g.johnston@g=
mail.com" target=3D"_blank">david.g.johnston@gmail.com</a>&gt; wrote:<br></=
div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"m=
argin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left=
:1ex"><div dir=3D"auto"><div><div class=3D"gmail_quote"><div dir=3D"ltr" cl=
ass=3D"gmail_attr">On Wed, May 22, 2024, 10:36 Ron Johnson &lt;<a href=3D"m=
ailto:ronljohnsonjr@gmail.com" target=3D"_blank">ronljohnsonjr@gmail.com</a=
>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px=
 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><di=
v dir=3D"ltr"><div>This doesn&#39;t work, and I&#39;ve found nothing simila=
r:</div><font face=3D"monospace">ALTER ROLE foo SET SEARCH_PATH=C2=A0 =3D &=
#39;*&#39;;</font></div></blockquote></div></div><div dir=3D"auto"><br></di=
v><div dir=3D"auto">Correct, you cannot do that.</div></div></blockquote><d=
iv><br></div><div>That would be a helpful feature for administrators, when =
there are multiple schemas in multiple databases, on multiple servers: supe=
rusers get=C2=A0<span style=3D"font-family:monospace">ALTER ROLE foo SET SE=
ARCH_PATH=C2=A0 =3D &#39;*&#39;;</span>=C2=A0and they&#39;re done with it.<=
/div></div></div></blockquote><div><br></div><div>It can be pretty dangerou=
s, because you don&#39;t specify order of schemas=C2=A0</div><div><br></div=
><div>Regards</div><div><br></div><div>Pavel <br></div></div></div>

--000000000000aebc23061910085b--