Category Archives: Security

SQL Server 2012 (“Denali”): New Security Features

SQL Server 2012 has many new security features, and three of the bigger new features are: Default Schema for Windows Groups, Audit enhancements, and User-Defined Server Roles. Default Schema for Windows Groups A database schema can now be tied to a … Continue reading

Posted in Security, SQL Server, SQL Server 2012, SQLServerPedia Syndication | 1 Comment

Setting role security in SSAS for a role-playing dimension

Here is a common got-ya.  You are modifying the cube dimension security for a role-playing dimension.  You make the changes and the cube processes successfully.  But when you try to connect to the cube, you get the following error message: The ‘XXX’ attribute in … Continue reading

Posted in Security, SQLServerPedia Syndication, SSAS | 2 Comments

Show correct totals when using SSAS role security

When using role security in SSAS, one point of confusion is when a person sees the grand total for a measure that includes the total of ALL members in the cube, even though the security has limited the members that person can … Continue reading

Posted in Security, SQLServerPedia Syndication, SSAS | 9 Comments