Hi all 1st post here,
Im creating a database at work and struggling with the security. I have a database to store projects for different sites. But I need to make it so the sites can only see there own.
So say i have 3 sites A,B,C i need it so only A,B,C can see their own, and then a 'management' level that can see all 3.
Is there a simple way of doing this?
I thought initially i could have one database with a different login for each site and they would only see what they create. This seems difficult.
Would it be easier/possible to have 3 seperate databases for each site, that then feed into one database for managers?
Thanks in advance
Lee