I am working on a number of datasets where I want to default users to the operating units they oversee without limiting them to just that one unit.
For example, when Joe in Miami clicks on a report, Joe should see just Miami's results. But, Joe should be able to see the overall organization's results as well.
Most of our employees are associated with just 1 operating unit.
Some are in charge of groups which have 6-10 operating units.
And some have organinzational responsibilities and have all operating units.
I have a table that lists all of the employee's along with the operating unit(s) within their purview. I understand how i could use row level security to limit their access. But, I just want to default them to their unit(s) without limiting their access.