BI Security - Secured view - real sql
Content
Hello,
I want to know if there is a way to get the real sql behind the secured view?
For example: CMP_SALARY_SECURED_LIST_V or PER_PERSON_SECURED_LIST_V or PER_ASSIGNMENT_SECURED_LIST_V.
I know how it works but I would appreciated to get the real sql behind. (How the view read the data role and security profile)
The documentation here: https://docs.oracle.com/cd/E51367_01/globalop_gs/OEDMH/CMP_SALARY_SECURED_LIST_V_view.htm doesn't describe the real view (we don't see how the security profile are taken into account)
Thanks
0