Forum Discussion

Clampazzo's avatar
Clampazzo
Icon for Resolver I rankResolver I
2 years ago
Solved

Can 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...
Need Help
  • GilbertQ's avatar
    GilbertQ
    2 years ago

    Hi Clampazzo 

     

    You could use SSMS to log into the XMLA end point and then script out the database?

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
2 years ago

Hi Clampazzo 

 

What I would do is to connect to the XMLA endpoint using tablet editor and create the roles using tabler editor. It would be a lot quicker and efficiently create your role and give them as working as expected.

  • Clampazzo's avatar
    Clampazzo
    Icon for Resolver I rankResolver I
    2 years ago

    Thanks 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's avatar
      GilbertQ
      Icon for Super User rankSuper User
      2 years ago

      Hi 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.

      • Clampazzo's avatar
        Clampazzo
        Icon for Resolver I rankResolver I
        2 years ago

        That sounds like a possibl workaround... is there any documentation on how to do that?