What you are looking to do is known as Row Level Security, and it is a certified BITCH to do in SQL Server. There is no easy/efficient way to do it. And it is certainly not something you can set up optimally based on some forum posts. 🙁