Do you have db_link between schemas?
No I don't think I do.
What would it do?
I would let you to join tables in different schemas using SQL.
I don't know if i understood your issue correctly, but you have USERNAME() function.
If you have on your data your user information, you can work with this function to filter only what he can see.
Create a calculation with USERNAME() and run a test.