List of users for a security role | D365FO

Views (48)

Community Member

Like(0)

Report

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 !!!

The post List of users for a security role | D365FO appeared first on .

This was originally posted here.