Need some advice on how to best handle this. I want to split my database and distribute to 6 users. Each user will have their own unique queries (due to the joins/criteria in each that are completely different) that are created off the same tables in the back-end, therefore, I'm thinking my only option is to create 6 distinct front-ends which will make automating any updates to forms, etc. cumbersome.
What type of performance issues, if any, might I encounter by doing it this way? If I create a single front-end, is there a way to hide queries that don't pertain to a particular user so they only see their own? There are 60 queries so we just want to keep it clean by allowing them to only see the 10 that are theirs.
Would appreciate any advice, thanks!
Toni