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 

 

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?

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

    Hi Clampazzo 

     

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

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

      I'm accepting as solution but I may ping back if I have more questions.  Thanks for your help.