I have a dashboard that has data in it for 500 locations.
I have a security table that shows which locations each user has access to in the back end system that this data came from. So this table will have a row for the userid and the location id for each location they should have access to.
When a user logs into the dashboard I want to only display the location or locations that user should be able to see. They can see the entire dashboard. But only for those locations.
I will also have managers that can see an entire division or region and are not limited to just a location. That information is also in this access table.