Re: Function and Tables Privilege
| От | Iande |
|---|---|
| Тема | Re: Function and Tables Privilege |
| Дата | |
| Msg-id | E19krhC-0002en-QJ@mail2.br.inter.net обсуждение |
| Ответ на | Function and Tables Privilege (Iande <iande@br.inter.net>) |
| Список | pgsql-novice |
An immediate hack comes to mind. Post it to a temp table, and have a super-user level trigger copy it out and update the real table. How the one functions gets to be super user, is beyond my knowlege. :-( <SPAN class=576332920-07082003> <SPAN class=576332920-07082003>---------- <SPAN class=576332920-07082003> <SPAN class=576332920-07082003>Interesting, but i supose i´m left with the same security problem, i don´t want the user to have direct access on update to that table, i wanted to restrict it to functions. From where i see it, this temp table would efectly give permission to update the real table, please correct me if i´m wrong. <SPAN class=576332920-07082003>and about the functions gets to be super user, i was thinking more around the possibility of getting the onwer´s permission, can this be done? :-( <SPAN class=576332920-07082003> <SPAN class=576332920-07082003>thx, <SPAN class=576332920-07082003> <SPAN class=576332920-07082003>Iandé <SPAN class=576332920-07082003>
В списке pgsql-novice по дате отправления: