Choosing static or dynamic RLS
Auditors all review the East region. Each regional manager sees only their own region, and more managers join soon. Adding an auditor must add no roles or UserRegion rows, and adding a manager must add no roles.
Use the controls to add auditors and managers. Which audience should use the dynamic role?
This exercise is part of the course
Data Ingestion and Semantic Models with Microsoft Fabric
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise