Thursday, 26 June 2014

CRM 2011/2013 SQL Query to Retrieve Users assigned to Field Level Security Profile

Here is the SQL Query to retrieve list of users under Field Level Security Profile:

In this example is “System Administrator”

select * from SystemUser
where SystemUserId in
    select SystemUserId from SystemUserProfiles
    where FieldSecurityProfileId in 
        select FieldSecurityProfileId from FieldSecurityProfile
        where Description = 'System Administrator'

Run the Test:

From UI:


From SQL Database Result:


Hope it helps!

No comments:

Post a Comment

My Name is..