To add a SQL user to a role, add the user to the required role through K2 Workspace> Management Console>Roles