ANNOUNCEMENT: community.oracle.com is currently Read only due to planned upgrade until 29-Sep-2020 9:30 AM Pacific Time. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
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?