Re: execute permissions of stored procedures?

Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
> ... But you'd still have to do
> the what users are allowed to call this function portion manually
> because that permission isn't available AFAIK (although it's been
> talked about as part of 7.3 development I think).

Actually, it's already been committed as part of 7.3 development:

2002-02-18 18:10 petere

* doc/src/sgml/catalogs.sgml, doc/src/sgml/release.sgml,
doc/src/sgml/ref/create_function.sgml,
doc/src/sgml/ref/create_language.sgml, doc/src/sgml/ref/grant.sgml,
doc/src/sgml/ref/revoke.sgml, src/backend/catalog/aclchk.c,
src/backend/catalog/pg_proc.c, src/backend/commands/define.c,
src/backend/commands/proclang.c, src/backend/executor/execQual.c,
src/backend/nodes/copyfuncs.c, src/backend/nodes/equalfuncs.c,
src/backend/parser/gram.y, src/backend/parser/keywords.c,
src/backend/utils/Gen_fmgrtab.sh, src/backend/utils/adt/acl.c,
src/backend/utils/adt/sets.c, src/backend/utils/cache/fcache.c,
src/backend/utils/misc/superuser.c, src/bin/initdb/initdb.sh,
src/bin/scripts/createlang.sh, src/include/miscadmin.h,
src/include/catalog/catversion.h,
src/include/catalog/pg_attribute.h, src/include/catalog/pg_class.h,
src/include/catalog/pg_language.h, src/include/catalog/pg_proc.h,
src/include/nodes/nodes.h, src/include/nodes/parsenodes.h,
src/include/parser/keywords.h, src/include/utils/acl.h,
src/include/utils/fcache.h,
src/test/regress/expected/privileges.out,
src/test/regress/sql/privileges.sql: Privileges on functions and
procedural languages

regards, tom lane