Inherited roles not deleted when user removed from group

martinsk
Mega Expert

Hi

This issue relates to roles which have been inherited by a user via membership of a group, which are then not deleted when that user is removed from the group membership.

Previously, I was able (as advised elsewhere in the Community) to export the records from table 'sys_user_has_role' to an XML file, then change the 'inherited' attribute to false, and then import the amended XML file back in to ServiceNow. In Jakarta this worked.

In London, when I attempt to import the amended XML file into the system, I get error 'Skipping record for table sys_user_has_role and id ************************** - permission denied'.

I have the admin role; I have used Elevate Roles; I have even disabled all write access controls on the sys_user_has_role table. I still get the error.

Any help with this would be much appreciated.

Martin

5 REPLIES 5

Thanks for your reply.

Yes, I think that's what I'll be doing.

Martin