Re: Simulating field-level permissions via stored SQL functions?

From: brichardson(at)lineone(dot)net (Bruce Richardson)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Simulating field-level permissions via stored SQL functions?
Date: 2001-08-17 21:23:19
Message-ID: 20010817222319.A22687@knossos.bruce
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 17, 2001 at 02:41:47PM -0400, Neal Lindsay wrote:
> I think that the subject line explains what I am trying to do. How can I
> create a stored function (in SQL, if that matters) that a user can call to
> update data in a table to which they normally only have read access?

By using a view. Triggers and rules attached to a view are executed
with the uid of the view owner.

--
Bruce

Anyone who slaps a 'this page is best viewed with Browser X' label on a
Web page appears to be yearning for the bad old days, before the Web...
-- Tim Berners-Lee

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tamara D. Blum 2001-08-17 21:24:00 Installing Postrgesql 7.1.2-3
Previous Message Tamara D. Blum 2001-08-17 21:10:16 Installing Postrgesql 7.1.2-3