Remove empty user from sys_user_has_role

Vasu1 · ‎08-04-2020

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 · ‎08-06-2020

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.

View solution in original post

Harsh Vardhan · ‎08-05-2020

you have to open the record one by one and there you will see form button "Delete" , so you can do it from there.

Anurag Tripathi · ‎08-06-2020

As an admin you should. if you dont then check the ACLs on that table.

If needed modify the ACL temporarily, delete the records and then revert the ACL.

-Anurag