Hi All,
I am working on a dashboard to audit roles assigned to users where the role name contains the “admin” keyword, and I need suggestions for handling multi-level role inheritance from sys_user_role_contains.
Example:
- User added to Group A
- Group A has Role X
- Role X contains multiple child roles
- Those child roles contain more roles
Since Database Views are not recursive, what is the best approach to report complete inherited role hierarchy for audit dashboards?
Are people using:
- fixed-level DB views,
- Script Includes with recursion,
- or some other approach?
Would appreciate suggestions from anyone who has implemented something similar.
