Re: [SQL] Execute permissions for stored functions

2004-01-18 Thread Tom Lane
Paul Hart <[EMAIL PROTECTED]> writes: > In RDBMSs such as Oracle, stored PL/SQL functions run with the > permissions of the user that creates the function. Users who are given > EXECUTE privileges then call the function with the permissions of the > creator of the function. Use "SECURITY DEFINE

[SQL] Execute permissions for stored functions

2004-01-18 Thread Paul Hart
Hi all, From what I've seen in the archives, questions like this have kind of been answered in the past, but I was wondering if there have been any changes in this area, or if anyone has good ideas on how to do what I'm about to ask :) In RDBMSs such as Oracle, stored PL/SQL functions run with