問題文
A regional sales table must show each sales manager only the rows for their own region. Region assignments change monthly and are maintained in a separate table. Which mechanism fits?
選択肢
- An aggregation policy with a minimum group size equal to the number of regions, which forces every result to be grouped by region before it is returned.
- A separate view per region, each filtered by a literal region code, and a monthly grant script that points each manager at the view for their current region.
- A row access policy whose body joins to the assignment table so that the visible rows follow the current assignments.
- A masking policy on the region column, which will hide the values of rows the manager should not see and therefore keeps those rows out of the manager's result set even though the rows themselves are still scanned.