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:

image

From SQL Database Result:

image

Hope it helps!

No comments:

Post a Comment

My Name is..