Re: Permission on insert rules - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Permission on insert rules
Date
Msg-id web-1821190@davinci.ethosmedia.com
Whole thread Raw
In response to Re: Permission on insert rules  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-sql
Robert,

> If the functions can fire as there creator instead of there caller,
> then
> I would think as long as the creator has insert/update views on the
> base
> table, you should be able to do updateable rules and give only
> permissions to the view for the caller. (Though maybe you have to use
> triggers rather than rules to do this?) Does that sound right?

I don't know.  Can you test it?

-Josh


pgsql-sql by date:

Previous
From: Robert Treat
Date:
Subject: Re: Permission on insert rules
Next
From: "Josh Berkus"
Date:
Subject: Re: bigger problem