Does the attached image show a record?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-25-2025 11:52 AM
From close reading of ServiceNow documenation and some on_demand course, my impression is the image below shows one user record. Prior to working with ServiceNow, I would have thought the image shows one user record plus 28 sys_user_has_role records, 29 records in all.
Which count is correct?
1 record
29 records
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-26-2025 07:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-27-2025 04:04 PM
Is sys_user_has_role a table?
Does it contain records?
Do rows in sys_user_has_role correspond exactly to each role the user has?
Does that mean the user record contains sys_user_has_role records?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-26-2025 07:48 AM
My thoughts from your image
1) it's 1 user record (sys_user)
2) that user is member of 1 Group (sys_user_group)
3) If you clearly see Roles Record there are total 45 (sys_user_has_role)
a) some are inherited = true means those roles got added to that user because of group membership and user got those roles because user is member of that group
b) some are inherited = false means those roles are directly given to user such as admin
If my response helped please mark it correct and close the thread so that it benefits future readers.