View My Drafts
I am trying to set up RLS for schools and have currently been coming across some issues. I have gone through a lot of videos multiple times and have not been successful. I was wondering if you all would be able to help me out here.
I have a kind of tricky situation. I feel like the solution should be pretty easy and I am not looking at it in the correct order. I am going to start explaining from the beginning. I have a students that holds basic student information.
This is where I am struggling to create a proper security table that would give principals access to all the students within their schools and teachers access to only their students.
Student IDs are distinctly connected to each student. Thus, it would happen if the student switched over to another school, but then his/her school ID would also be automatically be updated along with the teacher's information. A teacher can teach the same class in more than one school. So, if the student moves to another school and still takes the same teachers' class, then the teacher would be able to view his records.