Postgres: all procedures and their access lists

 SELECT

    r.rolname AS role_name,

    p.proname AS procedure_name,

    n.nspname AS schema_name,

    pg_get_function_identity_arguments(p.oid) AS arguments

FROM

    pg_proc p

JOIN

    pg_namespace n ON n.oid = p.pronamespace

JOIN

    pg_roles r ON has_function_privilege(r.rolname, p.oid, 'EXECUTE')

ORDER BY

    procedure_name, role_name;