how to give a scheduler job access to table data when using VPD
TiinaDec 20 2010 — edited Dec 21 2010Hi,
I have a sheduler job that needs to access all data from some tables, which are protected by VPD (virtual private database). It seems that scheduler jobs have APEX_PUBLIC_USER rights only, so the job has very limited access to the tables. When tables are accessed , the VPD adds a condition to the where clause that determines which table rows are available. I thought that maybe I could change the original condition so that if the job is trying to access the data, then all rows are available. The problem is how to safely make such a check ?
Tiina