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

[Rajshekhar Pau1]

Hi Gee,

Thanks for sharing the info. It's a good learning.

Please mark this question as Answered so that it can be removed from the bunch of unanswered questions. Also, if you want to mark any answer as helpful kindly do the same

Regards,

Rajshekhar Paul

[Inactive_use295]

For others who find this post.

I had same issue with orphaned records in sys_user_has_role table. These records were orphaned as "inherited=true".   It is necessary to set "inherited=false" PRIOR TO performing a successful recordDelete().

NOTE: I did have Contextual Security: Role Management Enhancements (com.glide.role_management.inh_count) activated in my instance but this was not solving or preventing the orphaned records. I have no information on why the records were orphaned.

[Oleksiy Kosenko]

It's amazing, thank you so much!

[georgeprad]

Thank you very much for this. I was having the same issue and your comment has helped me resolve it.

[Peter Carnocha1]

Yes, Setting inherited=false first is the key to successfully deleting these orphaned user role records.