"Tefft, Michael J" writes:
> I apologize, that was sloppy.
> I was using the acldefault() function with pg_roles, like this:
> => select rolname, acldefault('f',oid) from pg_roles where rolname like
> 'mjt%' order by 1;
Ah, yeah, that always shows the *built in* default privileges for a
given o
2 PM
To: Tefft, Michael J
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Removing the default grant of EXECUTE on functions/procedures to
PUBLIC
"Tefft, Michael J" writes: > I was checking
pg_roles. acl_default to see if my role-level ALTER DEFAULT PRIVILEGES had been
effect
"Tefft, Michael J" writes:
> I was checking pg_roles.acl_default to see if my role-level ALTER DEFAULT
> PRIVILEGES had been effective. But I see the same content both before and
> after the ALTEr.
Er, what? There's no column named acl_default in pg_roles, nor any
other standard PG view.
psql
be checking
instead?
Thanks,
Mike Tefft
From: Tom Lane
Sent: Friday, July 5, 2024 10:51 AM
To: Tefft, Michael J
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Removing the default grant of EXECUTE on functions/procedures to
PUBLIC
"Tefft, Michael J" writes: > I am trying t
"Tefft, Michael J" writes:
> I am trying to remove the default grant of EXECUTE on all
> functions/procedures to PUBLIC.
>> From my reading, there is no straightforward way to do this. For example,
> ALTER DEFAULT PRIVILEGES REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC;
> Does not apply this across th
On Friday, July 5, 2024, Tefft, Michael J
wrote:
> I am trying to remove the default grant of EXECUTE on all
> functions/procedures to PUBLIC.
>
> From my reading, there is no straightforward way to do this. For example,
>
> ALTER DEFAULT PRIVILEGES REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC;
>
> Do
I am trying to remove the default grant of EXECUTE on all functions/procedures
to PUBLIC.
>From my reading, there is no straightforward way to do this. For example,
ALTER DEFAULT PRIVILEGES REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC;
Does not apply this across the entire cluster (or database) but onl
