insert through function only - Mailing list pgsql-general

From Marvin McNett
Subject insert through function only
Date
Msg-id 4096C3B0.3080508@cs.ucsd.edu
Whole thread Raw
Responses Re: insert through function only  (Bruno Wolff III <bruno@wolff.to>)
Re: insert through function only  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: insert through function only  (Brent Wood <b.wood@niwa.co.nz>)
List pgsql-general
How do I go about ensuring that data is only added to a table through a
function?  I've tried granting execute persission on the function which
inserts data, but can't get it to work unless the user also has insert
permission on the table.  I don't want the user to be able to
arbitrarily insert data.


pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: 7.4.2 Regression tests: test stats loops indefinately...
Next
From: Bruno Wolff III
Date:
Subject: Re: insert through function only