From the course: SQL Server Analysis Services

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Implementing roles in your model to restrict data

Implementing roles in your model to restrict data - SQL Server Tutorial

From the course: SQL Server Analysis Services

Start my 1-month free trial Buy for my team

Implementing roles in your model to restrict data

“

- [Instructor] In the last video, we added some different roles. North America, not North America, and Deploy. Now, let's review how to test them. We will be, of course, doing this in Excel, but we're going to be using some different settings than we've used before. So when I click on the Excel ribbon, instead of just clicking on Current User, I'm going to change and select this Option button next to the role module. Since we've added some roles in the dropdown, we can now see the roles that we added. So, let's first select Deploy. Now, for the Deploy option we did not give ourselves any ability to read any data. So if we try to, it doesn't know what we want to connect to and we get no data connection whatsoever. Let's test some of the other roles. First, we're going to test the North American role. Using roles allows us to test data as if we were members of that role. So within Excel, let's add of course, Total…

Contents