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