Users groups and their rights

For protection of the information from unauthorized change or removal it is recommended to differentiate the access rights to data for various users.

The separation of access rights to the database in its essence is similar to differentiation of access rights in a local area network.

Access to the data of software server the «Passport of the field» in the local network:

Besides roles established by default in Microsoft SQL Server 2005 for databases (public, db_owner, db_datareader, etc.), in a database of software «Passport of the field» there are preset six roles:

Administrator - the administrator has the right to modify any information in a database. Has the right to add, delete and edit the list of users, to distribute them on roles.

Agronomist, Economist, Dispatcher and User - the root user has the right to modify the information in a database depending on settings of their rights, have the limited access to data. Each role carries out the action on entering and updating information relating to the work of role. It is forbidden to change the list of users and assign roles to them.

Observer - the user can access the information only for reading.