Received: from einhorn.in-berlin.de (einhorn.in-berlin.de [192.109.42.8]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA16636 for ; Tue, 15 Feb 2000 10:02:11 -0500 (EST) (envelope-from mkresse@slyde.in-berlin.de) Received: from slyde (DialIN071.vr.in-berlin.de [193.175.22.199]) by einhorn.in-berlin.de (8.10.0.Beta10/8.10.0.Beta10/Debian 8.10.0.Beta10-1) with ESMTP id e1FEvfD05304; Tue, 15 Feb 2000 15:57:41 +0100 Message-Id: <200002151457.e1FEvfD05304@einhorn.in-berlin.de> X-Authentication-Warning: einhorn.in-berlin.de: Host DialIN071.vr.in-berlin.de [193.175.22.199] claimed to be slyde From: "Martin Kresse" To: Jan Wieck Date: Tue, 15 Feb 2000 16:01:34 +0100 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: [SQL] "Permission denied" on public view CC: pgsql-sql@postgreSQL.org Priority: normal In-reply-to: References: <200002141832.e1EIWWR16053@einhorn.in-berlin.de> from Martin Kresse at "Feb 14, 2000 07:36:07 pm" X-mailer: Pegasus Mail for Win32 (v3.12a) > > However, when I try the exact same statement with a different user, > > I get the error message: > > ERROR: data: Permission denied. > > > > When I remove the ins_data rule, the INSERT works for the other > > users as well. Does the rule need access to the data table? Is this > > a bug or am I doing something wrong? > > Anything seems right for me. And I cannot reproduce this > error in the current developers tree (it works as it should). > > Which version of PG are you using? Today, I installed PG 6.5.3, which behaves exactly the same. Prior I have been using PG 6.5.1. Martin