Forum Discussion
Granular DataSet Permissions
We have a DataSet where we want to grant a user permission to manage row level security but we don't want him/her to view any direct query inside this DataSet. Also, we don't want him/her to add/update any query. How to achive this.
we want to grant a user permission to manage row level securityHave an Excel file (for example) with the RLS mappings on a sharepoint. Allow that user to modify the Excel file. Use that Excel file as a dimensional data source in your dataset, and drive RLS from it.
we don't want him/her to view any direct query inside this DataSetDon't give the user access to the dataset/report/workspace/app. Don't give them "Build" permisssions.
we don't want him/her to add/update any querysame
1 Reply
we want to grant a user permission to manage row level securityHave an Excel file (for example) with the RLS mappings on a sharepoint. Allow that user to modify the Excel file. Use that Excel file as a dimensional data source in your dataset, and drive RLS from it.
we don't want him/her to view any direct query inside this DataSetDon't give the user access to the dataset/report/workspace/app. Don't give them "Build" permisssions.
we don't want him/her to add/update any querysame