Security to secure access to the data in BI Publisher.

There were two set of users called X & Y.

User X is having Full Data access, where as Y has data access to limited countries.

With the help of PER_PERSON_SECURED_LIST_V trying to limit the data access. But both the users are getting same set of data.

select

           papf.person_number,ppnfv.first_name

from

           PER_PERSON_SECURED_LIST_V ppslv,per_all_people_f papf ,PER_PERSON_NAMES_F_V ppnfv

where

           ppslv.person_id = papf.person_id

           and sysdate between ppslv.effective_start_date and ppslv.effective_end_date

           and sysdate between papf.effective_start_date and papf.effective_end_date