Browse by Tags

• access
• Analysis Services
• powershell
• principal
• privileges
• security
• tsql
• view
• XMLA

• SSAS: Reporting on Metadata

  I had a comment recently on one of my older posts that I did about XMLA which asked about listing cubes in a database and whether the cube is processed and it's size. I have posted about a number of different ways of doing this over the last few years, Read More... Posted Tuesday, May 06, 2008 10:08 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: powershell, Analysis Services, metadata, XMLA

• Control metada visibility using few 'simple' statements

  You may be aware that a user in a SQL Server 2005 database can only see metadata that the user either owns or on which the user has been granted some permission. A default policy enhanced as compared to how a DBA can control the security access to the Read More... Posted Thursday, August 09, 2007 8:03 PM from SSQA.net | (Comments Off) Filed under: security, tsql, access, view, privileges, principal, metadata