Tag Archives: Security

TSQL Tuesday #63 – How do you manage security

  This month’s T-SQL Tuesday is hosted by Kenneth Fisher (blog | twitter) and the topic is security. Security is one of those subjects that most DBAs have to deal with regardless of specialty. So as something we all have to … Continue reading

Posted in Community, Programming | Tagged , , | 3 Comments

SSMS Quick Tip

If you ever need to test Analysis Services roles, you can easily do so either by browsing the cube or by means of a query. When browsing a cube through SQL Server Management Studio (SSMS) or Bisuness Intelligence Developer Studio (BIDS), you … Continue reading

Posted in Programming | Tagged , , , , , , , , | Leave a comment

Analysis Services Dimension Security – via AMO

As part of a portal our team is currently developing, I needed a way to push permissions set in the portal onto the Analysis Services instances present in the system. A big part of the solution is what we call … Continue reading

Posted in Programming | Tagged , , , | 1 Comment

How to setup basic dimension security in SSAS

SQL Server Analysis Services offers the possibility to create roles, whereby you can manage the access certain users will have to data in the cube(s) on the database. The following is a basic tutorial on how to create a role … Continue reading

Posted in Programming | Tagged , , | Leave a comment