Microsoft SQL Server 2008 R2 Specifiche Scaricare il pdf (Pagina 160)

140 CHAPTER 7 Master Data Services

Color table on the right side of the page. These icons indicate that the values in the table are

not editable. The rst two buttons above the table allow a user with Update permissions to

add or delete a member, but those buttons are unavailable here because the user has Read-

only permission. The user can also navigate through the hierarchy in the tree view on the left

side of the page, but the labels are gray to indicate the Read-only status for every member of

the hierarchy.

FIGURE 7-17 Read-only permission on a hierarchy

At this point in the example, the user has Update permission on the ProductCategory en-

tity, which allows the user to edit any member of that entity. However, you can apply a more

granular level of security by changing permissions of individual members of the entity within

a hierarchy. As shown in Figure 7-18, you can override the Update permission at the entity

level by specifying Read-only permission on selected members. The tree view on the left side

of the page shows a lock icon for the members to which Read-only permissions apply and a

pencil icon for the members for which the user has Update permissions.

FIGURE 7-18 Member permissions within a hierarchy

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

Nessun commento

Microsoft SQL Server 2008 R2 Specifiche Pagina 160