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


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

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



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