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.
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. |
|
|
|
|
|