Currently, we are using the standard subject area "Security - Roles and Privileges Real Time"; however, it does not support retrieving all three combinations together.
At present, we are only able to fetch:
- Users and Roles, or
- Roles and Privileges
but not a complete mapping of Users, Roles, and Privileges in a single report.
We have already raised an SR, and the recommendation provided was to submit a CCC request to get support from the product owner.
Additionally, we explored alternate approaches using underlying tables; however, we did not identify any suitable replacements within the subject area. As per Oracle’s recommendation, we understand that using internal ASE tables for BI report development is not advised.
Could you please suggest any feasible approach to obtain Users, Roles, and Privileges information in a single report?
Appreciate your guidance on this.
