Home Dashboard Directory Help
Search

Master Data Services subscription view permissions by Gavin Campbell


Status: 

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)
view

Description

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