Re: Permission on insert rules

Tom Lane wrote:

>Luis Sousa <llsousa@ualg.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