Received: from marte.Deuroconsult.ro (0@ns2.Deuroconsult.ro [195.179.253.164]) by hub.org (8.9.3/8.9.3) with ESMTP id WAA08223; Tue, 11 Apr 2000 22:49:22 -0400 (EDT) (envelope-from raul@brahms.ro) Received: from brahms.ro (C228.Deuroconsult.ro [195.179.253.228]) by marte.Deuroconsult.ro (8.9.3/8.9.3) with ESMTP id FAA23263; Wed, 12 Apr 2000 05:49:15 +0300 Message-ID: <38F3E447.6C87FDDE@brahms.ro> Date: Wed, 12 Apr 2000 05:49:44 +0300 From: Raul Chirea X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.5-15 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-bugs@postgresql.org, pgsql-sql@postgresql.org Subject: Foreign keys breaks tables permissions Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/58 Hi, If one does: create table master ( id integer not null, primary key (id) ); create table detail ( id integer not null, master_id integer not null, primary key (id), foreign key (master_id) references master (id) ); insert into master (id) values (1); 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 ? Regards, Raul Chirea.