Re: Function and Tables Privilege - Mailing list pgsql-novice

From Iande
Subject Re: Function and Tables Privilege
Date
Msg-id E19krhC-0002en-QJ@mail2.br.inter.net
Whole thread Raw
In response to Function and Tables Privilege  (Iande <iande@br.inter.net>)
List 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 by date:

Previous
From: Avi Schwartz
Date:
Subject: Re: Function and Tables Privilege
Next
From: Josh Berkus
Date:
Subject: Re: Performance