Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
T-SQL to get a list of User-to-Entity Update Permissions?

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

  • Wednesday, June 20, 2012 4:01 PM
     
     
    Sign In to Vote
    0

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

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

    Thanks,

    Mel

    Mel Suarez

     

All Replies

  • Monday, June 25, 2012 2:57 PM
     
     Proposed
    Sign In to Vote
    0

    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
    •