The CreatorCon Call for Content is officially open! Get started here.

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