Table/View names for direct and indirect relationship for roles

[msriram]

Hello  All,

Under User Access tab we see the Direct Entitlements and Indirect Entitlements. In which tables/views we can find the direct and indirect relationship between roles and Entitlements/App roles/Groups ?

[MHelmy]

Though I'm not sure, but I don't think the indirect role entitlements are actually stored anywhere. I believe they are calculated when needed (but I could be wrong).

Maybe Ahmed Nofal can help?

[AhmedNofal · Accepted solution]

You are right Mostafa. The relation doesn't exist one view/table although this might be possibly a good idea to think of creating a view that contains figures around directs/in-directs. 

There are a bunch of tables to be included (group tables/views, explodeduserentitlements tables/views, role tables/views, role model table/views, etc..) in order to get your desired output.