Received: from megazone.bigpanda.com ([63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9U07XP47901 for ; Mon, 29 Oct 2001 19:07:33 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id A9B56D5CB; Mon, 29 Oct 2001 16:07:30 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 9F6625BD3; Mon, 29 Oct 2001 16:07:30 -0800 (PST) Date: Mon, 29 Oct 2001 16:07:30 -0800 (PST) From: Stephan Szabo To: Oleg Lebedev Cc: Postgres SQL Mailing List Subject: Re: table permissions In-Reply-To: <3BDDE4F0.D5F5758E@waterford.org> Message-ID: <20011029160544.J11052-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200110/408 X-Sequence-Number: 5360 On Mon, 29 Oct 2001, Oleg Lebedev wrote: > Hi everybody, > I have a table called 'set' and I am trying to edit or insert an entry > there. I made sure that I have ALL permissions to modify that table, but > still I get the same error: > ERROR: activity: Permission denied. > > I don't know where 'activity' part came from, but there is a reference > to activity table in set table. > I know this is a very vague descritption of the symptoms, but I don't > know where to look to find out more info. I'll happily provide any > further details. What version of postgres are you running? I know that at one point we had a problem with requiring select & update permissions to the primary key table referenced by a foreign key.