From: "Josh Berkus" <josh@agliodbs.com>
Subject: Re: Permission on insert rules
To: Luis Sousa <llsousa@ualg.pt>, josh@agliodbs.com
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Date: Tue, 12 Nov 2002 09:29:44 -0800
Message-ID: <web-1822655@davinci.ethosmedia.com>
In-Reply-To: <3DD13751.1030100@ualg.pt>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit

Luis,

> That's what I already made. The problem is when I do the update, I
> permission denied in all the tables for update and insert. The user
> that's making this operation only have select privilege.
> Any way, I'm using version 7.2.1-2 for debian.

I can't reproduce the problem, and permissions did not get fixed
between 7.2.1 and 7.2.3.   So I'm pretty sure that you're missing
something, somewhere.

Please post:

1) The table definitions for the tables being updated.
2) The view definition and permissions 
3) The Rules statements defined on the view
4) A copy of your database session where your update is denied,
including the exact error message received.

Without that information, no futher help is available.

-Josh Berkus