Re: [HACKERS] Function Permissions

2003-10-26 Thread Christopher Kings-Lynne
CREATE FUNCTION ... SECURITY DEFINER; Read the 7.3 docs. Chris Telecontrol Networking wrote: Hi, I really need that a FUNCTION runs allways with this creator/owner permissions, and not with the user permission. In other words, my FUNCTION must execute several procedures as POSTGRES superu

Re: [HACKERS] Function Permissions

2003-10-25 Thread Bruno Wolff III
On Sat, Oct 25, 2003 at 15:11:06 -0200, Telecontrol Networking <[EMAIL PROTECTED]> wrote: > Hi, > > I really need that a FUNCTION runs allways with this creator/owner permissions, and > not with the user permission. > > In other words, my FUNCTION must execute several procedures as POSTGRES su

[HACKERS] Function Permissions

2003-10-25 Thread Telecontrol Networking
Hi,   I really need that a FUNCTION runs allways with this creator/owner permissions, and not with the user permission.   In other words, my FUNCTION must execute several procedures as POSTGRES superuser, and the tables its needs access/insert/delete/update has no permissions to normal user.