Re: Permission on insert rules - Mailing list pgsql-sql

From Luis Sousa
Subject Re: Permission on insert rules
Date
Msg-id 3DD26B26.3010100@ualg.pt
Whole thread Raw
In response to Re: Permission on insert rules  ("Josh Berkus" <josh@agliodbs.com>)
Responses Re: Permission on insert rules
List pgsql-sql
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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Permission on insert rules
Next
From: "Josh Berkus"
Date:
Subject: Re: Permission on insert rules