| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Telecontrol Networking <pglist(at)telecontrol(dot)com(dot)br> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Function Permissions |
| Date: | 2003-10-26 08:28:29 |
| Message-ID: | 3F9B85AD.9020107@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
> 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 ?
>
>
> ---------------------------------
> Marco Túlio Oliveira
> IT-Manager
> www.telecontrol.com.br <http://www.telecontrol.com.br>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2003-10-26 08:30:15 | Re: Timestamp docs weirdness |
| Previous Message | Christopher Kings-Lynne | 2003-10-26 08:19:16 | Re: round() function wrong? |