The Requirement: Our organisation works in ~30 countries and has 6 groupings of workers ("Core Competencies") within each country. We have a number of Objects with OWD = Private and we need to restrict record access to users who only have access to the Projects where the Country__c and Core_Competency__c = the User's Country & Core Competency.
The Problem: 30 countries x 6 Core Competencies = 180 groupings of Users that we need to open up access via Sharing Rules. Since Salesforce has a limit of 50 criteria-based sharing rules, we're in a pickle.
The Ask: What is the best approach for satisfying this requirement? Do we need to use Apex sharing or Flow, or am I missing something else obvious?
Thanks in advance!