Microsoft SQL Server 2008 R2 Specifications download pdf (Page 159)

Administration CHAPTER 7 139

Figure 7-15. An administrator with full access privileges would instead see the full list of func-

tional areas on the home page.

FIGURE 7-15 The Master Data Manager home page for a user with only Explorer permissions

Data security begins at the model level. When you deny access to a model, the user does

not even see it in Master Data Manager. With Read-only access, a user can view the model

structure and its data but cannot make changes. Update permissions allow a user to see the

data as well as make changes to it. To continue the security example, Figure 7-16 shows that

this user has Read-only permissions for the Product model (as indicated by the lock icon) and

Deny permissions on all other models (as indicated by the stop symbol) in the Model Permis-

sions tree view on the left. In the Model Permissions Summary table on the right, you can

see the assigned permissions at each level of the model hierarchy. Notice that the user has

Update permission on leaf members of the ProductCategory entity.

FIGURE 7-16 A user’s model permissions

With Read-only access to the model, except for the ProductCategory entity, the user

can view data for all other entities or hierarchies, such as Color, as shown in Figure 7-17, but

cannot edit the data in any way. Notice the lock icons in the Name and Code columns in the

1 2 ... 154 155 156 157 158 159 160 161 162 163 164 ... 235 236

No comments

Microsoft SQL Server 2008 R2 Specifications Page 159