Re: Permission on insert rules

Поиск
Список
Период
Сортировка
От Luis Sousa
Тема Re: Permission on insert rules
Дата
Msg-id 3DD26B26.3010100@ualg.pt
обсуждение исходный текст
Ответ на Re: Permission on insert rules  ("Josh Berkus" <josh@agliodbs.com>)
Ответы Re: Permission on insert rules  ("Josh Berkus" <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Permission on insert rules
Следующее
От: "Josh Berkus"
Дата:
Сообщение: Re: Permission on insert rules