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 ?

Debartha
Tera Contributor

In sys_user_has_role table, when inherited field is set as true. Then granted by field is show the group name which is granting the  role to the user. But it is coming empty for all the entries. why is this happening ?

 

5 REPLIES 5

Logan Poynter
Mega Sage
Mega Sage

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

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.

Daniel Oderbolz
Kilo Sage

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

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