It looks to me like you are planning to implement ROW LEVEL SECURITY…
For this search in this forum with key words: row level security
There is also a thread posted by STEVE KRANDEL regarding this.
If I find it, I’ll post it here.
If you need more information… let us know.
[Moderator Edit: Combined follow-up post here]
Here is the link of STEVE KRANDEL’s presentation.
https://bobj-board.org/t/33904/1
Hope this helps
BO_Chief 
(BOB member since 2004-06-06)