MIME-Version: 1.0
References: <CACX+KaPVTfcmt__Ogwsf7xomtcCABktiA8iSJ+iCxOdbzKNnUA@mail.gmail.com>
In-Reply-To: <CACX+KaPVTfcmt__Ogwsf7xomtcCABktiA8iSJ+iCxOdbzKNnUA@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Tue, 4 Feb 2025 16:47:02 -0500
Message-ID: <CAKAnmmL-pEXEreUPfk0khM8be8RDEf2G1MP_QXqgtWOxV25wUg@mail.gmail.com>
Subject: Re: Understanding ALTER DEFAULT PRIVILEGES Behavior in PostgreSQL
To: Ayush Vatsa <ayushvatsa1810@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000002ae02d062d57f5bc"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmL-pEXEreUPfk0khM8be8RDEf2G1MP_QXqgtWOxV25wUg%40mail.gmail.com>
Precedence: bulk

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

On Tue, Feb 4, 2025 at 1:50=E2=80=AFPM Ayush Vatsa <ayushvatsa1810@gmail.co=
m>
wrote:

> Also, what would be the best way to ensure that, by default, no roles
> (except the function owner) have any privileges on new functions created =
in
> my protected schema?
>
Create them in another schema altogether, then move it to my_schema once
the privs have been set.

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

>

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Feb 4, 2025 at 1:50=E2=80=AFPM Ay=
ush Vatsa &lt;<a href=3D"mailto:ayushvatsa1810@gmail.com">ayushvatsa1810@gm=
ail.com</a>&gt; wrote:=C2=A0</div><div class=3D"gmail_quote gmail_quote_con=
tainer"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex=
;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">=
<p>Also, what would be the best way to ensure that, by default, no roles (e=
xcept the function owner) have any privileges on new functions created in m=
y protected schema?</p></div></blockquote><div>Create them in another schem=
a altogether, then move it to my_schema once the privs have been set.</div>=
<div><br></div><div>Cheers,</div><div>Greg</div><div><br></div><div>--<br>C=
runchy Data - <a href=3D"https://www.crunchydata.com">https://www.crunchyda=
ta.com</a><br>Enterprise Postgres Software Products &amp; Tech Support<br><=
/div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex">
</blockquote></div></div>

--0000000000002ae02d062d57f5bc--