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.