Posted by: Charles Maitland | Wednesday 19 April, 2006

Analysis Services User Manager

I have mentioned that one of our major projects is a data warehouse, analysis cube reporting services build using SQL Server 2005.

One of the needs they have is for a tool that will allow them to easily manage the expected 850 users. The nature of the security model means that the security has to be applied at the dimension level and there will probably be about 800 roles for the 800 users.

In addition to the volume of users, the team who will be managing this, whilst technically smart, have neither the skills, time or need to learn and use the full SQL Server 2005 Management Studio.

As I could not find any simple tool out there that would just let them add, edit and remove Roles, Users and Permissions I have just written one. It is still in an early Beta stage but I have got my head around the object model so I hope most of the pain is behind me.

Once it looks smart enough I will post a spec and screen shot.



  1. I don’t suppose there’s any way you could share this app with the rest of the community, is there? I expect lots of people will want exactly this functionality…

  2. Chris
    I am hoping to. I am back in the office on Thursday when I can discuss it with the powers that be. It is still in a raw state but I am hoping to take it further. Drop me a line with any features or functionality you think would be useful.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


%d bloggers like this: