Parse out Admin Rights on SSAS for Deployments
My company has strict security requirements and without a clear way to isolate the ability for a developer to easily and with agility deploy their SSAS solutions to either the Development Server or Production Server we will be unable to use SSAS Tabular as our strategic data modeling/semantic tool going forward. The easiest solution for us would be to parse out the Admin Permissions or allow for a Custom Role to allow a development team to deploy to a shared SSAS Server (shared amongst different application teams from different lines of business where data isolation is imperative) in (Dev or Prod) without also granting them full administrator privileges as we need to abide by least based access requirements. If we cannot fix this security risk we will be unable to use SSAS Tabular in our strategic tool roadmap. We have already looked into the deployment utility, local workspaces, putting the solutions in a central location to then auto script to deploy, etc.
