Not able to impersonate user, the list is empty

Siris · ‎03-24-2025

Hi,

I am not able to impersonate users, the list is empty. Can anyone help me to solve this issue??

Dr Atul G- LNG · ‎03-24-2025

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0726447#:~:text=This%20can%20....

This can occur when orphaned records, or records where the user is empty, exist in the User Roles [sys_user_has_role] table. Orphaned records should never exist on the sys_user_has_role table, and they can cause issues if they do.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

AndersBGS · ‎03-24-2025

Hi @Siris ,

is the user active? is it a system user? Can you provide some more details?

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Siris · ‎03-25-2025

My Issue is I am not even able to delete the records from sys_user_has_role table, even though I find some records which are user empty

Dr Atul G- LNG · ‎03-25-2025

Hi @Siris

Do you have admin rights, or is there an ACL blocking you? When you try to delete, what error are you getting? Can you share a screenshot?

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************