Re: Referencial integerity problem

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.