The CreatorCon Call for Content is officially open! Get started here.

Inheritance Map for all roles

muhammed
Kilo Contributor

Hello,

is it possible to create an inheritance map which shows the relations/connections of all roles.

Thanks in advance.

Muhammed

1 REPLY 1

mike_bush
Kilo Guru

Muhammed,



You've spotted that roles can contain other roles - a very powerful facility (one could say "vital facility")



The linkage is maintained via an "mtm" type table called sys_user_role_contains



Out-of-box the ROLE view has ONE Related List called "Contains Roles" which points "down" the hierarchy.



I find it VERY useful to add the "reverse" related list - "Contained By" since that allows me to look "up" the hierarchy.



This may well give you all the answer you need, if not try writing a report around the mtm table.



Mike