Re: execute permissions of stored procedures?

Stephan Szabo <sszabo@megazone23.bigpanda.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