During one of my latest projects there was a business requirement to allow power user to manage cube authorization. The list of authorized users was rapidly changing during a day so it had to automatically affect cube authorization.
Giving a power user SQL Server Management Studio is not a go...
[More]