Having the ability to assign a record to multiple users.

Use case: Doing a group inspection/audit on a facility. I would like only users a and b to see this record but the next day the same users might be assigned to different facilities that they should only see.