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

138 CHAPTER 7 Master Data Services

create a new version by copying a previously committed version and allowing users to make

their changes to the new version.

FIGURE 7-13 Model versions

Security

MDS uses a role-based authorization system that allows you to congure security both by

functional area and by object. For example, you can restrict a user to the Explorer area of

Master Data Manager, as shown in Figure 7-14, while granting another user access to only the

Version Management and Integration Management areas. Then, within the functional area,

you must grant a user access to one or more models to control which data the user can see

and which data the user can edit. You must assign the user permission to access at least one

functional area and one model for that user to be able to open Master Data Manager.

FIGURE 7-14 Functional area permissions

You can grant a user either Read-only or Update permissions for a model. That permission

level applies to all objects in the model unless you specically override the permissions for

a particular object; the new permission cascades downward to lower level objects. Similarly,

you can grant permissions on specic members of a hierarchy and allow the permissions to

cascade to members at lower levels of the hierarchy.

To understand how security works in MDS, let’s congure security for a sample user and

see how the security settings affect the user experience. As you saw earlier in Figure 7-14,

the user can access only the Explorer area in Master Data Manager. Accordingly, that is the

only functional area that is visible when the user accesses Master Data Manager, as shown in

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

No comments

Microsoft SQL Server 2008 R2 Specifications Page 158