APEX

Hi,

I am building an application over some pre-existing database tables with vpd, for wich I have synonyms in my workspace schema and the appropriates privileges.

I did configure the "Edit Security Attributes" of my application to set the vpd. And it fact, when I run the application, it work well (I created a plsql region that showed a count on one of the tables with vpd).

However, my problem is OUTSIDE the application, when Im trying to define a report region on the same table. I always get the following message
"1 error has occurred
Query cannot be parsed, please check the syntax of your query. (ORA-28113: policy predicate has error) "

Every documentation I found about a policy predicate error is about setting the vpd for an application... but I found no clue for my specific case. Oh, I also tried to create a trigger on the "on logon" of APEX_PUBLIC_USER... it work in sqlplus, but I still get this error in Apex Application Builder.

Any hint would be very appreciated.

Thank you

Alain Lafond
SRIC