"Roberts, Jon" <Jon.Roberts@asurion.com> writes:
> Major Feature 3: Users will build their own functions to manipulate their
> own data and share the output with their department. PostgreSQL security
> currently does not secure the functions they write so the feature is not
> fully met.
Incidentally, are you really wedded to pl/pgsql functions?
It seems like it would be far more powerful to allow them to build up a
library of perl or python or whatever and put them in files in a blessed
directory. Then you could have a few standard functions which they could use
to call functions from those libraries.
-- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support!