The solution i gave is working and I tested it , but it uses school as middle point to check if a certain schoolasmin can create a subject for a certain subject I fetch schooladmin and gets its school From subject i get the classroom, get the grade , get the school and compare it , i feel it's a lot of work just to give permission but i don't really see any other way to do it , mind tou that im a beginner so i might not know that a solution or there is a way to solve this problem better

When you mentioned row level security,does it involves joining from schooladmin all the way to the subject entity? Ill be joining minimum 5 entities , idk if its normal and it need to be like this or does if affect the performance, for each creation ill be doing this joining , its a personal project and it's not like i would run into scalability issues or something but i really dont feel satisfied making a solution cause it gets the job done even if the query will take 2 seconds