public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Cosimo Simeone <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Need help understanding has_function_privilege
Date: Sun, 23 Mar 2025 07:50:21 -0700
Message-ID: <CAKFQuwZmXG7uKX0dH+5=RMHrpTkGXa-VG4gePAOTtP+vd+C=ig@mail.gmail.com> (raw)
In-Reply-To: <CAD1W9HUKn-u8HnfhVX8e7qib1pYssiuSHp+Lu=5iHzpGJUDMMg@mail.gmail.com>
References: <CAD1W9HXMUZ6mjBVhNQJGqLQkMnyQAc28OAqvCEpZ_rOEH=eDfw@mail.gmail.com>
<CAKFQuwZmk+xvU9WUyX7CudPW7A7M0Jz+nAS+PWZ1dvVpDPLzjA@mail.gmail.com>
<CAD1W9HUKn-u8HnfhVX8e7qib1pYssiuSHp+Lu=5iHzpGJUDMMg@mail.gmail.com>
On Friday, March 21, 2025, Cosimo Simeone <[email protected]> wrote:
> Hi, and thanks (both of you!)
> Shouldn't the
> create role my_user NOINHERIT;
> avoid this? And since not, why? :-)
>
>
We might need to improve documentation surrounding the public pseudo-role a
bit. Since it’s not a true group role I suspect inherit/noinherit doesn’t
apply. (You also cannot SET to it, nor admin it - not tested.) Losing the
execute privilege on every built-in function would be way too annoying.
David J.
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Need help understanding has_function_privilege
In-Reply-To: <CAKFQuwZmXG7uKX0dH+5=RMHrpTkGXa-VG4gePAOTtP+vd+C=ig@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox