Cube roles don't work properly – bug in Analysis ? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Cube roles don’t work properly – bug in Analysis ?

Hello All,<br /><br />I have the following problem. I believe it is a bug on the MS-Analysis Services side, but don’t know, how to solve it.<br /><br />My System:<br />- MS Windows 2003 Server<br />- MS SQL-Server 2000 Enterprise (SP4)<br />- MS Analysis Services 2000 Enterprise (SP4)<br /><br />Problem:<br /><br />Ther are several roles defined for a Cube, like Admins, Users etc. Sometimes get the users who are defined in the Users-Role a warn-message. It says like: You can not access this Cube because you do not have any permissions on this Cube.<br /><br />After displaying this message, I have checked the Users-Role for this Cube. Its check-box is active – it means Users-Role should actualy have fully permissions. But it is not so [<img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ />!]- If you click on "Test Role", it returns the same warn-message as mentioned.<br /><br />A temporary solution is to deactivate and activate the Users-Role manualy, then it works for a time.<br /><br />Does anybody have an experience like this and what is the reason/solution for that?<br /><br />Thanks alot in advance<br /><br />greating<br />Otto
Check this link, you will find many good articles on managing roles in cubes.