FGAC

 Hi

I configured Fgac with the procedure DBMS_RLS_ADD_POLICY for a table in a Data base 11R2, the predicate is rownum < 10,
the table have 100 rows.
when make a count on the table, it works, return count = 10, but when i search a specific register that i know exists the query not return rows. i thought  that the query returned the ten firsts registers that match with the where of the statement, but it not work.

why this issue?

what happen with join on tables with FGAC's?

Regards