MDS Subscription View Regeneration Without Dropping View - by Robert McGough

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
0
Sign in
to vote
ID 778473 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 2/4/2013 8:49:54 AM
Access Restriction Public

Description

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.
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