Todd Kover <kovert@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
