I want to delete a specific user's role from scripting

[Ravi Borade]

i've tried this but its not working as we can't delete the record even from table ui level 

also tried to switch to security admin and tried to delete it its not working

basically we can't delete this record

var gr = new GlideRecord('sys_user_has_role');
gr.addQuery('user','sys_id of the user');
gr.query();

while(gr.next()){
    gr.deleteRecord();
}

[Ankur Bawiskar]

Hi,

basically you are deleting all roles for that user via script?

Is that script not working fine?

Script looks fine to me

Any Before delete BR on sys_user_has_role is restricting the delete?

Are you running this script in scoped app?

Regards
Ankur

[Ravi Borade]

it worked but i used addEncodedQuery() and yess here i was removing all the roles belong to that specific user 

[Ankur Bawiskar]

@Ravi Borade 

Thanks for informing.

But the response you marked as correct doesn't relate to your question.

the answer marked as correct won't work for your requirement.

Regards
Ankur