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 SAA13491 for ; Thu, 18 May 2000 18:21:02 -0400 (EDT) (envelope-from mkresse@slyde.in-berlin.de) From: mkresse@slyde.in-berlin.de Received: from slyde (DialIN059.vr.in-berlin.de [193.175.22.187]) by einhorn.in-berlin.de (8.10.1/8.10.1/Debian 8.10.1-1) with ESMTP id e4IMKvT32127 for ; Fri, 19 May 2000 00:20:57 +0200 Message-Id: <200005182220.e4IMKvT32127@einhorn.in-berlin.de> X-Authentication-Warning: einhorn.in-berlin.de: Host DialIN059.vr.in-berlin.de [193.175.22.187] claimed to be slyde To: pgsql-sql@postgreSQL.org Date: Fri, 19 May 2000 00:19:36 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: Foreign keys and access privileges References: <200005181057.e4IAvXR09871@einhorn.in-berlin.de> In-reply-to: <23410.958661686@sss.pgh.pa.us> X-mailer: Pegasus Mail for Win32 (v3.12a) X-Archive-Number: 200005/76 > 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? Yes, it's still there (in 7.0). Try the following two tables: create table a(x integer primary key); create table b(y integer references a); grant all on b to public; When someone else than the owner tries an insert into b, he gets a 'Permission denied'. For the operation to be successful, he needs to have select and update privileges on a. Ciao, Martin