Topic: Prompt how to divide access rights to tables
Actually such question.
There is a task to create the collective DB which parts will be filled with users from different departments.
To divide simply forms inputs not a variant therefore as if that happens - will bring down against each other.
Share algorithm of implementation of access to the table with the rights.
Theoretically, it is necessary to create the table of users and the table of objects, then them to connect.
But here the table of users it is possible at programming layer ? Or for this purpose to create separate , and from the login form to walk there, to check the password and to assign the rights to the user.
In general, can it is a little chaotic, but I will be glad to any comment who practically was engaged in implementation of a such problem.