why not use an additional table relating Contacts and UserGroups? e.g.
ContactsAccess
int UserGroups.Id (FK)
int Contacts.Id (FK)
You could use a special value (e.g. zero (0)) to indicate unrestricted access ,or you could modify the Contacts table to indicate the permission type.
Jonathan Fingland
2009-06-07 05:36:17