Hi,
I am trying to restrict access to my database so the users can only see what they should only see.
For example, user Andrew should only be able to see students with a teacherid of 1 and a schoolid of 2. Where user Billy should only be able to access students with a teacherid of 3 and a schoolid of 4. User Charlie should only be able to access all students with a schoolid of 5.
At the moment, all users can access everything and I need to restrict these users access.
Can anyone help me with these and provide any solutions?
Thanks,
Rory