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 ?
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.
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?
Retrieving data ...