Monday, March 30, 2020

List of security roles for current user | D365FO

Introduction:
In this blog, we will see how we can get list of security roles assigned to a current user  

Solution: 
UserInfo         userInfo;
SecurityRole     securityRole;
SecurityUserRole securityUserRole;

while select securityRole
    exists join securityUserRole
        where securityUserRole.SecurityRole == securityRole.RecId 
    exists join userInfo
        where userInfo.id == securityUserRole.User 
        &&    userInfo.id == curUserId()
{
    info(securityRole.name);
}

Thanks for reading !!!