Todd Kover <kovert(at)omniscient(dot)com> writes:
> This revocation from public happens in our environment. Trouble is, I
> can not find where an indiciation that execute has been revoked from
> public in pg_catalog.pg_proc (or any other table for that matter). Is
> there a way to find this somewhere in the catalog?
pg_proc.proacl is what to look at. If that is NULL then it means the
function has default privileges (viz, public execute). If it's not NULL
then the function has whatever privileges it says.
regards, tom lane