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 !!!
Related posts:
Resolving SSL/TLS Secure Channel Trust Errors in Dynamics 365 Finance and Operations
How to change a Bill of material (BOM) item on a production order
How to Set Up a Local Development Environment for D365 Finance and Operations Without Azure Costs
Shopify Meets Dynamics 365 Finance and Operations: A Guide to Integration [Part 2]