Now I'm doing a real estate project, the requirements of the customers, each can rental stores,
For example there are stores A, B, C
Which stores A can only look at their homes, not watch others published
B can see his release and the A store houses.
Stores C can see all homes
Said so much means that each store needs, set up to see that a few stores data

Please provide a train of thought

CodePudding user response:

Is a simple permission
Find a table maintenance to the shop to see what the store can
When then check of the stores they can see what stores and then in the

Assume that permission table maintenance can see B, B A
Then check is the select * from table where housing release stores field in (select privilege maintained table stores coding from authority maintained table where=current was introduced into the code store)