Re: execute permissions of stored procedures? - Mailing list pgsql-general

From Tom Lane
Subject Re: execute permissions of stored procedures?
Date
Msg-id 868.1014224404@sss.pgh.pa.us
Whole thread Raw
In response to Re: execute permissions of stored procedures?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: execute permissions of stored procedures?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: execute permissions of stored procedures?  (Helge Bahmann <bahmann@math.tu-freiberg.de>)
Re: execute permissions of stored procedures?  (eric@datalink.nl)
List pgsql-general
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

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: execute permissions of stored procedures?
Next
From: Bruno Wolff III
Date:
Subject: Re: