Delete orphan records from sys_user_has_role table

[gee]

Hi Team,

I have an issue with deleting orphan records from sys_user_has_role table.

Tried with fix script to delete these records using GlideRecord, failed.

Delete button is disabled, even though schema level deletion is enable.

Also dried to deleted the user and imported the same user record using XML (user record export). Still role definitions are there!

Is there any method to delete these records from the above table?

Any suggestion please?

Platform is on Helsinki Patch 8.

Thanks & Regards,

Gee Abraham

[gee]

[Pradeep Sharma]

Please share your script.

[gee]

Hi Pradeep,

Here is the script that I have executed. Thanks, Gee.

----

var usr = new GlideAggregate("sys_user_has_role");

usr.addQuery("user", "7225d7164f03a2007b3be6518110c792");

usr.query();

while(usr.next())

  {

  usr.deleteRecord();

  usr.update();

  gs.log('********* sys_user_has_role ' + usr.role.name + ' ' + usr.granted_by);

  }

----

[Pradeep Sharma]

Hello Gee,

Replace

usr.deleteRecord();

  usr.update(); with

usr.setWorkflow(false);

usr.deleteMultiple();

P.S : Try this on dev instance first