Re: Function and Tables Privilege

From: Iande <iande(at)br(dot)inter(dot)net>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Function and Tables Privilege
Date: 2003-08-07 20:49:14
Message-ID: E19krhC-0002en-QJ@mail2.br.inter.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=576332920-07082003>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></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=576332920-07082003></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=576332920-07082003>----------</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=576332920-07082003></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial color=#0000ff size=2><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></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><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></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=576332920-07082003></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=576332920-07082003>thx,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=576332920-07082003></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=576332920-07082003>Iandé</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=576332920-07082003></SPAN></FONT>&nbsp;</DIV>

Attachment Content-Type Size
unknown_filename text/html 1.7 KB

Browse pgsql-novice by date

  From Date Subject
Next Message Jodie 2003-08-07 20:53:36 Upgrading from 7.1.3 to 7.2.3
Previous Message Avi Schwartz 2003-08-07 20:41:45 Re: Function and Tables Privilege