Question 560
An RLS role grants a user rows from two Region assignments, not only one. How should membership be represented?
Explanation
Correct Answer
Store multiple authorized user-to-region mappings where business policy permits. A mapping table can represent one user with several allowed data scopes.
Incorrect Answers
Row-level security filters semantic-model records for members of the role. It serves “sales team only its assigned fixed Region rows”, not “rows from two Region assignments, not only one”.
Visual and report filters are navigation aids, not security controls. The present requirement is “rows from two Region assignments, not only one”; “users cannot remove it to see other rows” is a distinct situation.
Identity-to-entity mappings allow model security to restrict related facts. The boundary it addresses is “a UserAccess table mapping users to allowed StoreIDs”, while this case concerns “rows from two Region assignments, not only one”.