Granular DataSet Permissions

[iqb]

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.

[lbendlin · Accepted solution]

we want to grant a user permission to manage row level security 

Have 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 DataSet

Don'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 query

same