In sys_user_has_role table, when inherited field is set as true. Then granted by field is show the group name . But it is coming empty. Please can any one say why is this happening ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-05-2022 03:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-05-2022 05:32 AM
Hello Debartha,
This is an odd one. Granted by field is a reference to sys_user_group. Have you made any alterations to that table or the attributes of this field at all before identifying this issue?
EDIT: Since I noticed you're in a PDI, I just logged into mine and see the same thing - empty granted by. Are you using San Diego? PDIs unfortunately do not receive much support here in the community, but if I come across anything I'll post back.
Please mark my answer as correct/helpful if it has helped you.
Thanks,
Logan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-05-2022 12:20 PM
Hi Logan,
Thanks for your response to my question. I haven't made any kind of changes in 'sys_user_group' table and that behavior I have noticed in my PDI as well as in a sub production instance of my organization. Those two instances are in San Diego and Rome, accordingly.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2023 07:26 AM
Hi @Deb
I think this is due to this plugin: Prevent duplicate entries with Contextual Security: Role Management V2 (servicenow.com)
In fact, the fields
- granted_by (used only by Role Delegation)
- included_in_role
- included_in_role_instance
Where deprecated with this plugin and are not maintained anymore.
Best
Daniel
If this answer was helpful, I would appreciate if you marked it as such - thanks!
Best
Daniel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-09-2024 09:55 AM
Hi Daniel,
I don't know why when its not maintained ServiceNow Support team itself asked me to install this plugin to remove orphaned/duplicate records.
If you can help with any resolution for this? I have never done roll back of any plugin. Not sure if its a correct process. Please help?
Thanks,
Vaishnavi