From the course: SQL Server Analysis Services
Join today to access over 24,600 courses taught by industry experts.
Modifications to the model to support row-level security - SQL Server Tutorial
From the course: SQL Server Analysis Services
Modifications to the model to support row-level security
- [Instructor] The first step to add role level security is to create a role. To do that, we're going to be selecting this role icon here on the ribbon and this is going to bring up the Role Manager window. Now the first thing we need to do is create a role or two. We're going to create roles for reprocessing and for administration. So to do that, we're going to select the New button and call the new role North America. For permissions we are going to select Read. We are going to do this and go ahead and say New, create a new role. And for this new role we are going to call it Not North America, and permissions are also going to be Read. Then we're going to add a last role and we're going to call this role Deploy. And under Permissions we're going to give it process rights. So for our roles we have North America, Not North America, and Deploy. And the permissions are read, read and process. Now that we have created the…
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.