Access Groups and Roles

RMiller19 · ‎10-27-2023

How do I find/create/access a report that has all of our access groups and roles that has information about what access they have and where?

Dr Atul G- LNG · ‎10-28-2023

Hi @RMiller19

There are mainly 3 tables used.

1. sys_user_has_role --> To check which user has which role assigned.

2. sys_user_grmember --> User is part / mapped to which group.

3. sys_group_has_role --> Which role assigned to which group

So now you can create different reports as per your need in these tables. If you want to combine tables, then create the Database view.

*************************************************************************************************************
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]

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

View solution in original post

Dr Atul G- LNG · ‎10-28-2023

Hi @RMiller19

There are mainly 3 tables used.

1. sys_user_has_role --> To check which user has which role assigned.

2. sys_user_grmember --> User is part / mapped to which group.

3. sys_group_has_role --> Which role assigned to which group

So now you can create different reports as per your need in these tables. If you want to combine tables, then create the Database view.

*************************************************************************************************************
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]

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

RMiller19 · ‎10-30-2023

Thank you very much, that was very helpful.