Roles Not Removing from User

[yana7]

I'm trying to remove roles from a user, but they're not being removed.

1. [Image 1] This is the user I want to remove roles from.

   

2. [Image 2] I've removed the roles in the Edit Role section and saved.

   

3. [Image 3] The roles are still listed in the Related list tab.

   

When I check the User tab from the Role itself, the user account is still there.

What should I do  to Remove Roles?

[Vaishnavi Lathk]

Hi,

Try below script-

var userRole = new GlideRecord("sys_user_has_role");
userRole.addQuery('role','PUT SYS ID OF ROLE');
userRole.addQuery('user','PUT SYS ID OF USER FOR WHICH ROLE NEEDS TO BE REMOVED');
userRole.query();
if(userRole.next()){
userRole.deleteRecord();
}

Regards,

Vaishnavi L

[yana7]

This doesn't work

[SN_Learn · Accepted solution]

Hi @yana7 ,

Please try the below in background script:

var userRole = new GlideRecord('sys_user_has_role');
userRole.get('61737f1bc36602103869d64d050131ee'); //Replace SysId of the role relationship in the [sys_user_has_role] table
userRole.inherited = false; //Updating it to false, then only we will be able to delete it.
userRole.update();
userRole.deleteRecord();

Highlighted sys_id is what you need to replace in the above code as per your requirement

Note: Please try in non prod first and check and it is not recommended to run background script in Prod.

Mark this as Helpful / Accept the Solution if this helps

[yana7]

it works,Thank you very much friend