| From: | Luis Sousa <llsousa(at)ualg(dot)pt> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Permission on insert rules |
| Date: | 2002-11-13 15:09:26 |
| Message-ID: | 3DD26B26.3010100@ualg.pt |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Tom Lane wrote:
>Luis Sousa <llsousa(at)ualg(dot)pt> writes:
>
>
>>When inserting, using the rule, the insert that's defined on the rule
>>works fine, but the insert defined inside the function, doesn't (that's
>>the one that gives permssion denied).
>>
>>
>
>Right. As of 7.3 you can fix this by making the function "setuid" (ie,
>it runs with the permissions of the function owner, not the caller).
>
>
There's any way to insert data inside the tables, using the functions,
called by the rules, without giving direct access to the user ?
I don't know, using a trigger or any kind of structure !!??
Regards,
Luis Sousa
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2002-11-13 17:29:46 | Re: Permission on insert rules |
| Previous Message | Tom Lane | 2002-11-13 14:27:01 | Re: Permission on insert rules |