I am pretty new, I am seeking some guidance here, how does one approach a problem like this: Want to create a database in a hosted services setting where there are three groups – A, B, and C. There are several members in each group. Group A must have access ONLY to the data it has uploaded, likewise group B must have access ONLY to the data it has uploaded. Groups A and B must have NO access to each other’s data. However, group C must have the access to both group A’s data and group B’s data and also upload it’s own data.
chemquiz 0 Newbie Poster
drjohn 56 Posting Pro in Training
Create several sets of separate queries, each stored in a password protected folder, one for each group.
The queries simple retrieve what each group is allowed to see.
Included a posted_by field in the database and the queries.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.