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 superuser,
> and the tables its needs access/insert/delete/update has no permissions to normal
> user. Only calling my FUNCTION the normal user can do that, and never updating or
> deleting directly over the tables.
>
> Any idea ?
You can use security definer clause when creating the function.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
