February 26, 2010 at 7:03 am
Is there a way one can query the properties of SSAS roles in a cube and expose the results in a report?
I want this report to show for the specific role:
- role membership
- access to data sources
- access to dimensions
- access to cell data
I also want to be able to see which user/member is assigned to which Role and their rights.
Is there a tool that can do all this?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 26, 2010 at 8:35 am
Is Analysis Management Objects (AMO) a good way to go?
Anyone have any AMO code that does similar things that they could share?
Also any other feedback on AMO would be appreciated.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply