Forum Discussion
Clampazzo
Resolver I
2 years agoCan I add a role for RLS Using XMLA Endpiont and C#?
I have managed to create a new semantic model using XMLA Endpoint and C# but now I need to be able to create Roles for RLS using the same method. Is this allowed? And if so How can I go about doing...
Clampazzo
Resolver I
2 years agoThanks for the reply GilbertQ , while that would be easy to do I need to dynamically create these datasets. They will all be DirectQuery but I am creating a new dataset (sometimes multiple) per client workspace. So going in manually later would be difficult to do.
If there's a way to copy a template dataset and then modify it using xmla (while keeping roles) that would be acceptable too.
GilbertQ
Super User
2 years agoHi Clampazzo
One option might be to script after the database after you have created the roles. You can then use this script to reapply to other app workspaces with the roles as part of the script.
- Clampazzo2 years ago
Resolver I
That sounds like a possibl workaround... is there any documentation on how to do that?