Do you have any BR to remove Role? 

Any parent child relationship between  sys_user_has_role and sys_email?

 

Please Accept the solution if it assisted you with your question & Mark this response as Helpful.
Regards
Tanushree Maiti
ServiceNow Technical Architect
LinkedIn: https://www.linkedin.com/in/tanushreemaiti