Thanks for the quick answers on the requirement for update permission
to go along with referential integrity. Now I understand things
better. (Perhaps more info for the docs?)
So if each table access requires locks for update on multiple tables,
is there any chance of deadlocks? Or are the multiple locks obtained
all at once in some sort of atomic manner that eliminates the problem?
Thanks again for your help.
Cheers,
Brook