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 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 error message refers to the referenced table.