It would be helpful if Row Level Security could be defined on entities within a Data Flow, so that a single data flow could be used as a repository for different users (with different access rights) to get data.
3 Comments
- Absolutely. I'd be fine with having to have a new dataflow for each change in the relevent role field, or per table. That would let me be certain the data was secured even if a report writer got lazy on the dataset.
- Added my vote. We use dynamic RLS to restrict viewers of reporting data from a financials system to see only the same transactions they would be allowed to see on the source system itself. However, we want power users to be able to create their own datasets based upon these restricted data sources and, for example, their own Excel-on-SharePoint sources. This is not possible at present because (a) a dataset cannot bring in data from another dataset and (b) if we use a data flow instead, this blows open the security model.
- Status added:Needs Votes
