Re: Permission on insert rules

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: Luis Sousa <llsousa(at)ualg(dot)pt>, pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Permission on insert rules
Date: 2002-11-11 17:59:56
Message-ID: web-1821190@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-11-11 18:13:29 Re: bigger problem
Previous Message Robert Treat 2002-11-11 16:45:40 Re: Permission on insert rules