From the course: SQL Server Analysis Services
Join today to access over 24,600 courses taught by industry experts.
Restricting data for different users - SQL Server Tutorial
From the course: SQL Server Analysis Services
Restricting data for different users
- [Instructor] Security is a really important feature for all data models 'cause there are times you want to restrict data being shown to different users. Perhaps you only want salespeople to look at their sales but not that of their peers. You may want to restrict data by region or by division. Since you want to provide rules for groups of users, ideally, you should create groups of users in active directory groups rather than enter users individually. Management of which users are included in those groups need to be maintained to ensure that only users with the appropriate levels of access will be added to different groups. To restrict what users have the ability to see, you will need to create roles and assign groups or individual users to the roles. You have a number of different options for what you can restrict with a given role. You can completely restrict access to a given table, like salaries, or something more…
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.