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

[RahulRAJAS]

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 ?

[Dr Atul G- LNG]

Hi @RahulRAJAS 

Use script as shared

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

[RahulRAJAS]

didn't work Atul

[Dr Atul G- LNG]

Hi @RahulRAJAS 

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

[Ankur Bawiskar]

@RahulRAJAS 

No scripting required

-> navigate to sys_user_has_role table

-> search for your inactive user

-> the Right Click Data Management -> Delete All with preview

this script in global scope in background script will work fine

(function() {
    var userId = 'sys_id_of_the_user'; // Replace with actual sys_id

    var roleGR = new GlideRecord('sys_user_has_role');
    roleGR.addQuery('user', userId);
    roleGR.query();

    while (roleGR.next()) {
        // Only process if the role is inherited
        if (roleGR.inherited == 'true') {
            roleGR.deleteRecord();
        }
    }
})();

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏