We use Active Directory groups for authentication for the most part. But I'm not sure what to do if a user is a member of multiple groups.
Group1 is persons who have some extra level of access to the various tables and records
Group 2 is persons who can add and modify some records in some tables
Group 3 is persons who can view records
Let's say that user "waterstc" is a member of all three groups.
I know that the order the groups are listed is the order that FMP uses to match a user/authentication with a privilege set. But is there a way to force the user's login to a group that sits further down the list, or will that user only be able to authenticate within the group that is highest on the list?