sql query to assign system admin and system user role to all users In d365 finance in ssms

Question

Hi Team,
I need to write a sql query in Ssms to assign system admin and system user security role to all the users. Please help

Answer 1

For example -
How can I write below x+ + code in sql query format in MS sql server management studio

static void SR_AssignRoleToAllUsers(Args _args)

{
SecurityRole role;
SecurityUserRole userRole;
boolean added;
Advertisements

REPORT THIS AD

UserInfo            userInfo;  
;  
 
select role where role.Name == ‘Budget clerk’;  
while select userInfo  
{  
    select * from userRole  
        where userRole.SecurityRole == role.RecId &&  
            userRole.User == userInfo.id;  
 
    if (!userRole || (userRole.AssignmentStatus != RoleAssignmentStatus::Enabled))  
    {  
        info(strFmt(‘Role %1 added to the user %2 successfully.’, role.Name, userInfo.id));  
 
        userRole.User = userInfo.id;  
        userRole.SecurityRole = role.RecId;  
        userRole.AssignmentMode = RoleAssignmentMode::Manual;  
        userRole.AssignmentStatus = RoleAssignmentStatus::Enabled;  
        SecuritySegregationOfDuties::assignUserToRole(userRole, null);  
    }  
    else  
    {  
        warning(strFmt(‘skipping – Role %1 to the user %2.’, role.Name, userInfo.id));  
    }  
}  

}