Role Inheritance Map - By all roles/groups not by user

[Nathan Dupuis]

Hi everyone,

I'm currently trying to understand the roles hierarchy and would like to see if there's a method of doing the following.

Currently, you can view a Inheritance map by specific user by using the "sys_user_has_role" table.  Here you can see what groups are associated to what roles. 

What I'm looking for, is basically the same thing, except it would just show me a list of all groups in the system, and what role they tie into, rather than only seeing it 1 user at a time. This would give us a full view of the setup on the entire structure.  

Is there a way to show this information?

Thank you for the assistance.

Nathan

[Nathan Dupuis]

It would be this, without user leading the hierarchy.