Re: Priviliges and Roles

On Mon, Feb 27, 2006 at 12:09:48PM +0000, Dayo Johnson wrote:
> Hello,
>
> Is it possible to do the following:
> Disallow permission to write to a table (either by UPDATE or INSERT) but
> allow EXECUTE permission on a Function that writes to the table ?
>
> The reason I want to do this is so that I can perform certain checks on
> the data that is being written before I allow it to be written.

I'm no expert but check out triggers. That should allow you to whatnot
the data and fail/pass the insert or update.

See: http://www.postgresql.org/docs/8.1/interactive/triggers.html

--
    "To the extent that we overreact, we proffer the terrorists the
    greatest tribute."
        - High Court Judge Michael Kirby