You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BI Security - Secured view - real sql

edited Dec 12, 2016 2:03PM in Applications Security 2 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!