Re: [BUGS] Referencial integerity problem

2001-02-12 Thread Stephan Szabo
Under 7.0 you needed update permission on the referenced table to grab the necessary locks. Under 7.1 you won't need this anymore. On Thu, 8 Feb 2001, Mike Howard wrote: > Briefly, I create two tables, one having a column which references the > other and which implements cascade deletes and up

[BUGS] Referencial integerity problem

2001-02-12 Thread Mike Howard
Briefly, I create two tables, one having a column which references the other and which implements cascade deletes and updates. I create a user who has modify access on one table, but only select on the referenced table. This user is not allowed to insert a record into the referencing table - the