Wednesday, March 7, 2012

Assign Cube User Access Without Being Admin?

Is it possible to set up a "low-level" administrator account in Analysis Services that only allows a user to assign other users to a particular Role?

We have an enterprise app where users in the field will need to call a help desk to gain access to the cube, but we only want the help desk people to be able to perform that one function. We would like to avoid building a custom admin tool that provides the proper restriction. Ideally, the help desk would use SQL Server Management Studio to perform this specific task while prohibiting any other admin abilities. Is this possible?

--
Joe

No, unfortunatelly this is not possible. If you already have tool by which helpdesk can assign users to existing NT groups, then you can include these groups into SSAS roles - and helpdesk personell won't need any access to SSAS.

No comments:

Post a Comment