SSAS Admin Perms Needed To Deploy Cube

• mnDBA

  SSCrazy

  Points: 2032

  More actions

  November 24, 2010 at 1:50 pm

  #157333

  In order to allow my developers to deploy test SSAS databases/cubes, I need to grant them SSAS Server Administrator rights?? There has to be a more granular permissions set.

  This hardly fits the least privileged model.

  What am I missing?

• amit_gupta01

  SSChasing Mays

  Points: 605

  More actions

  December 1, 2010 at 11:10 pm

  #1257728

  You can create role at analysis services database level and assign access accordingly:

  Roles access

  1) Full control

  2) Process database

  3) Read definition

  More details can be find in blog mentioned below:

  http://www.msbiconcepts.com/2010/10/ssas-data-security-dimension-and-cell.html

  Thanks,
  Amit G
  http://www.msbiconcepts.com