How to create a role to give access to Adhoc quary only for a particular countrie's data?
I have created a role with PA20(only for US) access and Adhoc query.
I am successful in restricting PA20 only for US but when the user executes adhoc query, she is able to view all the data for all countries.
I want her to access only US data through adhoc query. Could you please help me solve this?