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 ?

[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! 🙏

[RahulRAJAS]

tried both Ankur, but didn't work

[Ankur Bawiskar]

@RahulRAJAS 

without you sharing the script and debugging results we can't help

[RahulRAJAS]

I am saying that I have tried the options and script you have mentioned. Those options didn't work

[Ankur Bawiskar]

@RahulRAJAS 

even from UI Data Management it didn't delete?

so if you have debugged anything share the outcomes