Introduction

Tabular models leverage the use of Windows users and groups. Recall that in Chapter 5, Administration of Tabular Models, you added row-level security to a user to filter for one role to only see Ice conditions in the crash data. When the query is run, the security is checked to ensure that the user's role has the ability to retrieve the rows of data associated with the permission of the role, unlike multidimensional security, which uses cells and dimensions to determine what data can be accessed. In addition, tabular models do not have the ability to deny permissions such as does the multidimensional model. Tabular models rely on row-level security only. If a user is assigned to multiple roles, they obtain the rights from all the associated roles; for example, if the Read_Ice user is added to the Admin role, they would have all rights as an administrator as well. Pay close attention when setting up and deploying security. Tabular model security can be configured to use row filters...