Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA51202 for ; Thu, 18 May 2000 10:55:02 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id KAA23413; Thu, 18 May 2000 10:54:46 -0400 (EDT) To: mkresse@slyde.in-berlin.de cc: pgsql-sql@postgresql.org Subject: Re: Foreign keys and access privileges In-reply-to: <200005181057.e4IAvXR09871@einhorn.in-berlin.de> References: <200005181057.e4IAvXR09871@einhorn.in-berlin.de> Comments: In-reply-to mkresse@slyde.in-berlin.de message dated "Thu, 18 May 2000 12:57:29 +0200" Date: Thu, 18 May 2000 10:54:46 -0400 Message-ID: <23410.958661686@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200005/50 mkresse@slyde.in-berlin.de writes: > Now, with Postgres 7.0 RC1, when some user (not the owner of the > db, of course) tries to update, change or insert anything into > choice, he gets an error message that says 'Permission denied' for > table users. IIRC this is a known bug in RC1 (permissions not handled correctly for foreign key references). Have you tried it in 7.0 final? regards, tom lane