Search

Master Data Services subscription view permissions by Gavin Campbell

Active

1
0
Sign in
 to vote
Type: Suggestion
ID: 776499
Opened: 1/14/2013 9:07:48 AM
Access Restriction: Public
0
Workaround(s)
It would be useful to have subscription views created in a separate schema (presumably in addition to the current MDM schema) in order to be able to grant select permissions on this schema to our Power(pivot, view) users, who query this data directly.

At present, the choices appear to be granting select permission on the MDM schema itself (which causes too much stuff to appear in the Excel dropdowns) or granting select permissions on individual views, which incurs maintenance overhead when new entities are added.
Details (expand)

Product Language

English

Category

Master Data Services

Proposed Solution

Create a new schema and add subscription views to it.

Primary Benefit

Improved Administration

Other Benefits

 

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Gavin Campbell on 1/22/2013 at 10:27 AM
It occurs to me that it might even be an idea to make these schema names user defined per subscription view; configurable from the create view dialog. This would enable separation between two different ETL processes (for example) that needed to access different subsets of the subscription views.
Posted by Microsoft on 1/22/2013 at 10:21 AM
Hi SQLSophist,
Thank you for your feedback - this is an interesting request. We can consider how we might want to make this change, possibly for a future release. I will leave this item open for now. Thanks!
Lynn
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement