Search

MDS Subscription View Regeneration Without Dropping View by Robert McGough

Closed
as Won't Fix Help for as Won't Fix

2
0
Sign in
 to vote
Type: Suggestion
ID: 778473
Opened: 2/4/2013 8:49:54 AM
Access Restriction: Public
0
Workaround(s)
In the current version of MDS (SQL 11 PCU1), subscription views must be regenerated in order to reflect changes to the related entity. When this is accomplished by editing and saving the affected subscription view, permissions granted to the view are lost, indicating that the change is being made by dropping and recreating the view.

In the situation described above, select permissions are being granted on the MDS database to specific views because not all users should have access to all entities in the model.
Details (expand)

Product Language

English

Category

Master Data Services

Proposed Solution

Could subscription view updates possibly be implemented as an alter in a future release in order to preserve assigned permissions?

Is there a workaround to avoid losing permissions when view are updated either in MDS or in the way permissions are assigned?

Primary Benefit

Improved Administration

Other Benefits

 

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 2/6/2013 at 11:25 AM

Hi Robert,
Thank you for making this suggestion. We appreciate hearing from you. We will likely not be able to make this change in an update to the current release, but I am marking it for consideration in the next version. We will also continue to monitor this Connect item, if there are further comments. Thanks!
Lynn
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement