1

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.

2

Re: Prompt how to divide access rights to tables

File of working group, mdw.

3

Re: Prompt how to divide access rights to tables

rurikovi4 wrote:

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.

The Table departments :
- _
- Department
Input Tables:
-
- _
- ....
To implement through forms:
1. Department identification at start (it is received _).
2. For entry forms and adjustment in a condition of selection (filter) _, it and value by default
For new records of tables.
It agrees  (to differentiate departments). If demarcation to users, instead of departments the table Users is necessary;
But then the general picture for department is not visible (either one user or all users of all departments in a heap)...
It is better to fasten on access the qualifier Departments--> Users so more floppy
(Too it is at first sight chaotic, but each cashier works iron for me on network sale sees only
The checks, the manager sees the full picture)

4

Re: Prompt how to divide access rights to tables

All depends on how at you the system is organized. An example of how identification of records is organized at us at the enterprise.
Costs Windows Serwer. All users are registered in it. Each user is tied up to the department. (Department - the group, this business of system analysts) In  to basis exist one/two/three auxiliary tables. One - users, it is present always. Remaining - depending on the structural organization of the enterprise. (The table of departments, the section table, the table of groups. It is possible to use and one table constructed by a principle of an interval tree.) in important tables there are two auxiliary weeding - a field with user number from the table of users and a field with date where date of entering of record registers. That's all. All remaining depends on desire and ability of the programmer. It is possible to create various samplings who when entered what record.
There are more difficult systems of recording. Wrote systems which not only considered, who that when entered but also who that when who changed also that when deleted.

5

Re: Prompt how to divide access rights to tables

Yes, forgot to add. At start of any program of operation with basis Windows-identification of the current user which is rigidly registered in  to the table of users is requested. If the user in  to the table is not present, the program is closed.
Yes, and direct access to tables for users is closed. Only through programs and forms!