Remove empty user from sys_user_has_role

[Vasu1]

Help requested

How to remove (empty) user from sys_user_has role.list? 

we recently cloned from prod to sub instance dev and in sys_user_has_role.list found empty(25) records. 

[Harsh Vardhan]

i have checked on my personal instance, its visible and i can delete the record as well. 

[Harsh Vardhan]

make sure inherited set as false on those record . then this button will be visible.

[Vasu1]

thanks harshvardhan,

please can you guide to do inherited set as false. to do this role has to be elevated?

Best

Sri

[Harsh Vardhan · Accepted solution]

without doing any changes in ACL the only option is , use background script to update it to false. eg:

var gr = new GlideRecord('sys_user_has_role');

gr.addEncodedQuery('user=22d0ed7fdb08b300798979e49f961977');
gr.query();
while(gr.next()){
gr.inherited=false;

gr.setWorkflow(false);

gr.update();
}

Now you will able to see the delete button on that record as well list , but on list name will be like "Remove user access from table"

Screenshot for reference. 

[Vasu1]

Thank you so much harshvardhan.