Master Data Services (MDS) - list of users permissions

• NicHopper

  SSCrazy Eights

  Points: 9090

  More actions

  January 18, 2022 at 8:39 pm

  #3974374

  Hi all,

  I'm trying to get a list of all the user/entities permissions for my Master Data Services,

  for example

  UserA-------------Model A ----------Entity 123------------------Read permissions.

  UserA-------------Model A ----------Entity 456------------------Write permissions.

  I found a couple of scripts which mention mdm.udpSecurityPrivilegesSummaryGet  but it doesn't reallye do the job.

  So I wondered if anyone had any query or method of getting this information.

  Thanks,

  Nic

  Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  January 19, 2022 at 9:10 pm

  #3974971

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.