Thank you for the quick response, Jake! 🙂
Just to get an idea on the magnitude of data, I have a total of 5 million cases, 1500 users across 400 organisations and a total of around 100 permissions.
Can the above proposed schema serve this kind of volume well or can we optimize it?
Thanks again