Tuesday, 20 August 2019

Get Security Roles Name from MS CRM On-premise using SQL Query

How to get Security Roles Name from MS CRM 2011/2013/2015/2016/D365 On-Premise using SQL query

SELECT r.Name FROM Privilege p

JOIN RolePrivileges rp on p.PrivilegeId = rp.PrivilegeId

JOIN Role r on r.RoleId = rp.RoleId

where p.Name = 'prvMerge'





Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)