Advanced Dimension Data Security with SQL Server 2008
On a recent project, my client asked if we could secure members of a dimension by Active Directory groups. For example, in a dimension named "Region", there might be a "Southeast" region. Members of the A/D group named Southeast should only be able to view the "Southeast" member. Below is an example of this, built using the AdventureWorks database. In this example, the Geography dimension is secured.
Read more...