Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.3/8.9.3) with SMTP id OAA08097 for ; Mon, 14 Feb 2000 14:00:47 -0500 (EST) (envelope-from wieck@debis.com) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@postgreSQL.org id m12KQa6-0003knC; Mon, 14 Feb 100 19:50 MET Message-Id: From: wieck@debis.com (Jan Wieck) Subject: Re: [SQL] "Permission denied" on public view In-Reply-To: <200002141832.e1EIWWR16053@einhorn.in-berlin.de> from Martin Kresse at "Feb 14, 2000 07:36:07 pm" To: Martin Kresse Date: Mon, 14 Feb 2000 19:50:46 +0100 (CET) CC: pgsql-sql@postgreSQL.org Reply-To: Jan Wieck X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > 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? Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #========================================= wieck@debis.com (Jan Wieck) #