We have an application that have various levels of security such as "isadministrator" and "isuser". These filters are used to limit the interactive report data displayed. This security is based on the user logged into the system. When using the interactive tools all work fine including sending email reports. Unfortunately the Subscription always sends empty reports, this i suspect is due to the fact that there is no user logged in to run the report (the scheduler is running the report) so no authority exists and filters out all data.
where lower(manager_id) = lower(:APP_USER)
Is there any way to pass the full (resolved) SQL to the scheduler?