Does the attached image show a record?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
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
3 weeks ago
Hi @LFleming
The image shows 1 user record, and that user has 45 roles and is part of 1 group..
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
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
3 weeks ago
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader