Setting a Database activity to 'separate groups' does not restrict the view for users. I tried both the activity group mode setting and the course group mode setting. Groups tested for the course was:

Group 1->subgroup 1a->user1
Group 2->subgroup 2a->user2