Cacher is the code snippet organizer for pro developers

UPDATE dbo.TreeMasterRepository
SET IsRestricted = 0

--Revert Expert Engineer Role
DELETE urx FROM dbo.UserRoleXNode urx
INNER JOIN dbo.UserXRole ux ON urx.UserRoleId = ux.Id AND ux.RoleId = 8
DELETE FROM dbo.UserXRole WHERE dbo.UserXRole.RoleId = 8
DELETE dbo.RoleMaster WHERE Id = 8

--Add IsExpert in UserRoleNode
UPDATE dbo.UserRoleXNode
SET IsExpert = 0