All challenges
Sharing & VisibilityArchitect
Role Hierarchy at 80k Users
3 decision points371 grounded questions
The scenario
A multinational has 80,000 users across 12 levels of role hierarchy. Ownership changes trigger sharing recalculations that run for hours and lock records; group membership changes ripple endlessly. Reps must see their region; executives must see everything; a new 'restricted PII' requirement must HIDE some records even from people above in the hierarchy. Design a model that scales.
Constraints to satisfy
- Sharing recalculation must not run for hours on ownership change.
- Some PII records must be hidden even from senior roles.
- Regional visibility without per-user rules.
- Group membership churn must stay manageable.
Think through your own design first - data model, timing, failure modes. Then walk the decision points and defend each choice against a worked architecture.