CLR Stored Procedures in Sql Server Analysis Services (SSAS)
I've been doing some R&D work on a new integrated security model for our database/analysis services lately, with one of the main requirements being a system where security changes made to the Sql server database will automatically propogate through to the SSAS environment.
Tags: amo, security, stored procedure