User roles inherited but not from group and roles are not manually added. unable to delete them

RahulRAJAS
Kilo Guru

Hi 
 I found an inactive user with roles but not added in any group or not manually added. all the roles say inherited true. Unable to delete them from sys user has role table and background script also didn't work.
how to deleted these roles ?

1 ACCEPTED SOLUTION

even from the data management it is not getting deleted, so I have raised a HI case and they have provided me this article
Role Management Inheritance Issues - Support and Troubleshooting
and suggested this as next steps
Next Steps:
We need to run a script to remove the discrepancies for inherited roles.
Please note that this is a standard change and doesn't cause any harm to anything. This will only fix the records in 'sys_user_has_role' table.
So kindly provide your consent and a suitable time window to implement this CHG directly on your prod instance.

View solution in original post

10 REPLIES 10

Dr Atul G- LNG
Tera Patron

Hi @RahulRAJAS 

 

Use script as shared

https://www.servicenow.com/community/developer-forum/removing-roles-of-inactive-users/m-p/1365936

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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

didn't work Atul

Log a case mate in this case buddy.

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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

Dr Atul G- LNG
Tera Patron

Hi @RahulRAJAS 

 

https://www.servicenow.com/community/developer-forum/how-to-remove-roles-and-groups-for-inactive-use...

 

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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