Greetings,
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
Query Output:
| Role Name | Description
| Membership Type | Assigned On | Request ID | Start Date | End Date |
|---|
role1 | 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
Thanks!