List of users for a security role | D365FO

In this blog, we will see how we can get list of users who has assigned a specific security role  


UserInfo         userInfo;
SecurityRole     securityRole;
SecurityUserRole securityUserRole;

while select networkAlias from userInfo
        where userInfo.networkAlias
    exists join securityUserRole
        where securityUserRole.User ==
    exists join securityRole
        where securityRole.RecId == securityUserRole.SecurityRole
        &&    securityRole.Name == 'Sales manager(NameOfTheSecurityRole)'

Thanks for reading !!!

Share Story :