Robert Boyd wrote at 2005-10-25 12:59 -0400:
... I'm seeing that if I assign a role on an object to a user, then delete the user, the object still lists the user as having the local role - and I can assign the non-existant user more local roles, too. Thus, no referential integrity between users and local roles. I suppose any of my code dealing with local roles can try to get the user first before displaying their id, to prevent showing these non-existant role-holders. Anyone deal with this issue before?
A well known problem. You have to implement your own cleanup code: When you delete a user, visit all objects with local roles for this user and remove them. This can get more efficient when you define an appropriate index (otherwise, locating the objects may take a very long time). -- Dieter