Empty User in sys_user_has_role

Valentina6
Giga Guru

Hi developers,

do you have an idea about empty user information in sys_user_has_role table records? What it depends on? Solutions?

find_real_file.png

Many thanks,

Valentina

5 REPLIES 5

Chuck Tomasi
Tera Patron

Hi Valentina,



The first thing to check is the ACLs.



The second thing to check is the display attribute on the sys_user table. If this were off, it would show users as blank in other places as well (like the caller field on the incident form or members in the related list on the groups.)


Jaspal Singh
Mega Patron
Mega Patron

Hi Valentino,



Could you confirm if this is what you get when you view as Admin or as an End User. If as an End User then you need to add an ACL as below on User table.



Operation IS Read


Table is User(sys_user) and corresponding Dropdown field on the side will be empty (Ensuring Table Level access).


Thanks everybody.


I have the admin role and the read acl on sys_user is opened, it has no role and no conditions.All acl's on sys_user and on sys_user_has_role tables haven't be touched, are ootb.



Best regards,


Valentina


corina
ServiceNow Employee
ServiceNow Employee

Hello,



Just a wild guessing, do you do any imports into the table sys_user_has_role ?