Learning -> How to achieve Fusion Security into Custom BIP Reports through SQL?

Summary

Apply fusion security into custom-sql reports

Content

Hi,

Can anyone please help?

I am in the process of developing a few custom reports using sql/bip option and would like to enforce the same security that of Fusion Learning Module within the reports.

There are no secured views for Learning objects (WLF%) and if I join WLF% tables with either of the below-secured views, I dont see the data because my learning roles does not have the relevant roles to access the data:

1) PER_PERSON_SECURED_LIST_V (must have duty roles -> Documents of Record Transaction Analysis, Payroll Transaction Analysis and Workforce Transaction Analysis)