From the course: SQL Server Analysis Services
Join today to access over 25,300 courses taught by industry experts.
Challenge: Implement model security - SQL Server Tutorial
From the course: SQL Server Analysis Services
Challenge: Implement model security
(upbeat music) - [Instructor] For this challenge we're not really going to be writing much DAX. Instead, we're going to be adding roles and implementing role level security by filtering columns. We are going to start by opening up the exercise files and opening up CH06, going to the Begin folder, and opening up our Solution file. This is where we are going to start creating our roles. Now we're going to be doing that by selecting this icon here, the Roles icon. And all the work we're going to be doing is here in the Role Manager. So we are going to be adding roles and implementing row level security by filtering some of the content that you can see in a given role. This will restrict access to the data depending on which role users are assigned to. We're going to create a role called ReadData. To do this, you'll go to the Role Manager and create a new role called ReadData. You'll set the permissions to Read and then, in…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.