From: Josh Berkus <josh@agliodbs.com>
To: Luis Sousa <llsousa@ualg.pt>
To: josh@agliodbs.com
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Permission on insert rules
Date: Tue, 12 Nov 2002 09:29:44 -0800
Message-ID: <web-1822655@davinci.ethosmedia.com> (raw)
In-Reply-To: <3DD13751.1030100@ualg.pt>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, llsousa@ualg.pt
Subject: Re: Permission on insert rules
In-Reply-To: <web-1822655@davinci.ethosmedia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox