none
T-SQL to get a list of User-to-Entity Update Permissions?

    Question

  • Does anyone have SQL that lists MDS Entity-related permisions?

    I'm looking for a list of User, Entity, CRUD.

    Thanks,

    Mel


    Mel Suarez

    Wednesday, June 20, 2012 4:01 PM

All replies

  • Hi Mel,

    Try using the udpSecurityPrivilegesSummaryEffectiveGet stored procedure.  It returns the effective permissions for a given user.


    Brian Barnett
    http://www.profisee.com
    brian.barnett@profisee.com
    “As the original creators of Microsoft MDS, Profisee's Master Data Maestro provides a range of enterprise-grade functionality to ensure MDS project success.”

    • Proposed as answer by Brian Barnett Tuesday, June 26, 2012 2:46 PM
    Monday, June 25, 2012 2:57 PM