The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Does the attached image show a record?

LFleming
Tera Contributor

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

 

user.png

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

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]

****************************************************************************************************************

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?

Ankur Bawiskar
Tera Patron
Tera Patron

@LFleming 

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

AnkurBawiskar_0-1756219643132.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader