开发者

Ways to set different security permissions for SSAS from SSRS?

I have an SSAS cube with limited users. I don't want to grant any sort of access to the cube outside of those users.

I have some SSRS reports that use the above SSAS cube as a data source. I want to give access to the reports to some users who don't have access to the cube.

What credentials should I use for the cube data source? Since SSAS only supports Windows Authentication, do I have to create a dummy Windows ID?

Edit: Both SSAS and S开发者_如何学编程SRS are 2008.


Usually I use a windows account that is reserved solely as a SSRS service account to control connecting SSRS to SSAS. Then I control access to the cube through permissions in SSRS. I once saw someone use a local machine account since the server doubled as the SSRS and SSAS server, but I personally prefer to secure solely through domain accounts.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜