List of users for a security role | D365FO
Introduction:
In this blog, we will see how we can get list of users who has assigned a specific security role
Solution:
UserInfo userInfo;
SecurityRole securityRole;
SecurityUserRole securityUserRole;
while select networkAlias from userInfo
where userInfo.networkAlias
exists join securityUserRole
where securityUserRole.User == userInfo.id
exists join securityRole
where securityRole.RecId == securityUserRole.SecurityRole
&& securityRole.Name == 'Sales manager(NameOfTheSecurityRole)'
{
info(userInfo.networkAlias);
}
Thanks for reading !!!