We need to build a query that takes a user and lists all their roles. The problem is that I need to have a column that says whether the role in question is given to the user directly or indirectly with inheritance. OIM does this within the self service portal, but I need a query. What tables would I need to get this information, or what SQL query would be able to help make this happen?
Query Input: username
|Role Name||Description||Membership Type||Assigned On||Request ID||Start Date||End Date|
|this is a role||Direct||1/1/1999||123456||1/16/1999|
|role1.5||this is a role of a roll||Indirect||1/1/1999||123457||1/16/1999|
This question is similar, but nothing helpful was gained from the answers. Query regarding Role Inheritance needed