Achieving data display to countrywise authorized users
Hi <b>B</b>est and <b>W</b>ise gurus,
The scenario is like this:
There are two characteristics ZUSER(user) and ZCOUNTRY(country). The country refers to the
country in which the user is authorized to view data.
User and Country exhibit a many to many relationship.(one user can have authorization in
many countries and vice versa).
Also,the number of users and the countries is very large.
How can we achieve the following?
When a user logs in, the output of the query should be such that the user is able to see the
data pertaining to the country/countries in which he/she is authorized.
Thanks and regards,