Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 How to know who has access to the cube?

Author  Topic 

pras2007
Posting Yak Master

216 Posts

Posted - 2010-08-06 : 09:53:46
What would be the easiest way to generate a list of users that have access to the cubes?

Please advice?

Thanks.

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2010-08-07 : 08:03:04
One way to retrieve rights for your SSAS cubes is using SOAP XMLA discover option using XMLA Query.
The second way is to connect to your SSAS server, select desired cube and drilldown on rights to see who has access granted on particular cube.

you can also set query logging for SSAS cubes usages to track who and how many times use particular cube.
Go to Top of Page
   

- Advertisement -