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.
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.... |
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 |
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 |