Re: Removing the default grant of EXECUTE on functions/procedures to PUBLIC - Mailing list pgsql-general

"Tefft, Michael J" <Michael.J.Tefft@snapon.com> 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 object kind and owner.  If there's a relevant entry in
pg_default_acl, it overrides the built-in default during object
creation.

            regards, tom lane