How do I restrict a list's View access by user roles? I have a list with multiple Views (one per country). Each view restricts columns (country-specific) and filters rows based on country. I want to restrict the view to the respective country roles that I have created. I will give only one role to each user. So, when the user opens the list, he/she should see ONLY the view he/she is assigned to. How can i do this?
This is not possible out of the box. View is not a security trimmed feature (ie like SQL view tables) What you could do is to have multiple folders in the list and then brake the inheritance per folder so when user goes to list it just see folder he has rights to. For admins and staff that has access to all items you can create 'flat' view that will show all items without folders.