Friday, March 23, 2012

How to allow normal user (not Administrator) deployment of SSAS Cube?

Hello,

how to allow normal user (not Administrator) deployment of SSAS Cube? It says always that normal user cannot create new objects.

Andrey.

In order to create a database you need to be an Analysis Server admin.

In order to create cubes, dimensions, partitions you need to be database administrator.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

If you want your user to work with a BI project (that he will edit in Visual Studio and then deploy), these are the things to do:

- you need to create the database yourself (empty database) as server admin

- you need to give user admin rights for the database (using SQL Management Studio, create a Role)

- then user can deploy the BI project. Important: his project needs to contain the Role definition specifying him as admin (otherwise when he deploys the project, he will cut his access). To ensure you have the Role definition, you could initially create the BI project out of the live empty database (from VS, chose New Project, Import Analysis Services 9.0 Database wizard; then make sure that the newly create BI project specifies in its properties your database name).

Adrian Dumitrascu.

|||

I created a Cube from my DataWarehouse.
Under Administrator account I can deploy the Cube and everything is fine.
Then I want to allow normal user (programmer) to develop and deploy it in Business Intelligence Development Studio. This user has no Administrator rights.
So, I receive something like "User _xxx_ has no rights to change _yyy_-objects or an object does not exist" (my translation from German).

Granting user all rights to the DataWarehouse, creating Role in SQL Management Studio for DataWarehouse does not help. What really helps: creating Administrator Role for user in SSAS project and deploying project to Analysis Service under Administrator! So, this role will be uploaded to the service. After this, service recognizes user as an Administrator!
If you try to deploy project for the first time under user, then the role will not be uploaded (no rights). If you try to create role in SQL Management Studio instead of in BI project, then user will update service, remove role from service (since there is no role in project) and after this will be non-recognizeable.
It is possible also to create role in SQL Management Studio and then identical role in BI project. And then user can deploy.

Thanks for help! It gave a clue :)

No comments:

Post a Comment