Foreign keys breaks tables permissions

From: Raul Chirea <raul(at)brahms(dot)ro>
To: pgsql-bugs(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Foreign keys breaks tables permissions
Date: 2000-04-12 02:49:44
Message-ID: 38F3E447.6C87FDDE@brahms.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers pgsql-sql


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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mark Hollomon 2000-04-12 07:45:48 Re: Re: postgresql rule bug
Previous Message Kevin P. Neal 2000-04-12 02:21:53 Minimal patches for PostgreSQL 7.0b3 on NetBSD/alpha 1.4.1....

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2000-04-12 12:25:49 Re: [SQL] Foreign keys breaks tables permissions
Previous Message Bernard Frankpitt 2000-04-08 22:20:19 Re: [HACKERS] Doc updates

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Lockhart 2000-04-12 04:20:36 Re: [HACKERS] SQL92 specification ....
Previous Message tjk@tksoft.com 2000-04-11 22:32:39 Re: Threaded Records in SQL: Advice Needed