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 IAA79367; Wed, 12 Apr 2000 08:33:13 -0400 (EDT) (envelope-from wieck@debis.com) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@postgresql.org id m12fMDN-0003lFC; Wed, 12 Apr 100 14:25 MET DST Message-Id: From: wieck@debis.com (Jan Wieck) Subject: Re: [SQL] Foreign keys breaks tables permissions In-Reply-To: <38F3E447.6C87FDDE@brahms.ro> from Raul Chirea at "Apr 12, 2000 05:49:44 am" To: Raul Chirea Date: Wed, 12 Apr 2000 14:25:49 +0200 (CEST) CC: pgsql-bugs@postgresql.org, 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 X-Archive-Number: 200004/62 > > Hi, > > If one does: > > [...] > grant select on master to a_user; > grant select, insert, update, delete on detail to a_user; > > then if login as "a_user" and does: > > insert into detail (id, master_id) values (1, 10); > > this will result in: "ERROR: master: Permission denied". > > This seems a bug to me ? Isn't it ? Outch, yes, we missed something here. Peter, you said you'll probably work on the ACL stuff after 7.0. We need to coordinate that work with the function manager redesign to go for SETUID triggers and functions. 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) #