Re: [BUGS] Re: [SQL] Foreign keys breaks tables permissions

2000-04-12 Thread Peter Eisentraut
Jan Wieck writes: > 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. Yes, very nice feature. Far down the road in my dreams though. However, SQL has a REFERENCES privi

[BUGS] Re: [SQL] Foreign keys breaks tables permissions

2000-04-12 Thread Jan Wieck
> > 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". > > T