Hi, and thanks (both of you!)
Shouldn't the
create role my_user NOINHERIT;
avoid this? And since not, why? :-)
On Thu, 20 Mar 2025 at 15:07, David G. Johnston
wrote:
> On Wednesday, March 19, 2025, Cosimo Simeone
> wrote:
>>
>>
>> true?
>> Well... Ok, "whatever"... I revoke it:
>> =# revoke
On Friday, March 21, 2025, Cosimo Simeone 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
On Wednesday, March 19, 2025, Cosimo Simeone
wrote:
>
>
> true?
> Well... Ok, "whatever"... I revoke it:
> =# revoke execute on function my_schema.my_func(text) from my_user;
> REVOKE
>
Roles can inherit privileges. my_user is inheriting its execute privilege
from PUBLIC. You have to revoke a g
On 3/19/25 04:24, Cosimo Simeone wrote:
Hi!
I'd need help understanding what i am doing wrong...
Where am I:
=# \c
psql (15.8 (Homebrew), server 14.15 (Debian 14.15-1.pgdg120+1))
You are now connected to database "postgres" as user "postgres".
Init:
=# create role my_user;
=# create schema my_s
