Tom Lane writes:
> I also don't see any privilege of this type in SQL92 (which does have
> the concept of setuid functions, in the form of modules).
SQL99 has setuid functions in the form of setuid functions, with a syntax
like CREATE FUNCTION .... SECURITY { INVOKER | DEFINER } (too lazy to look
up the details). There were some peculiar differences IIRC, such as
trigger functions executing with the permission of the trigger creator
(which is yet different).
Modules are more like "packages", AFAICT.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter