/ Access control / Chapter 87. Permissions to GDB and its components / Granting and revoking permissions to GDB and its componentsThe page “Tables” of the property sheet “Properties of user” is shown at figure 87-4.
Figure 87-4. Property sheet “Properties of user”, page “Tables”
A list of tables of the current GDB is given in the list pane. The checkbox General permissions to tables is shown at the figure in checked state, that is why checkboxes of permissions display general permissions with respect to all tables.
Access – this is the basic permission to tables providing inclusion of selected table into the list of tables of the current GDB.
If this permission is revoked for a particular table, its name will not be displayed in the list of tables for the present user. If this permission is revoked on the level of general permissions to all tables, type of components “Tables” will not be displayed in the tree of GDB structure for the current user.
Revoking access to the table also revokes access to all cataloged queries for which this table is the base one or is used as a reference table.
This permission has a higher level than other permissions to maps described below. Clearing the box Access leads to clearing remaining boxes.
Access via queries only – like permission to maps via themes only this “right” is more an “obligation”. If this permission is set for a table, the user cannot work directly with a table: browse table structure and its records, build queries on the basis of the table and so on. Possibilities of access to table data are limited for him only to work with existing cataloged queries, and he cannot get access to those table fields which are not included into the query.
Resetting permission only via queries does not reduce but on the contrary increases the total volume of user permissions since it means getting permission not only via queries.
Setting permission only via queries revokes the right to change table structure.
Structure changing – this permission gives a possibility to change structure of selected table, that is, add, remove and rename fields, change their attributes. Besides, this permission allows removing a table.
If permission to change structure has been revoked at the level of general permissions for all tables creating of new tables is disabled.
Permission to change table structure can be granted only in the case if permission to change GDB structure is given.
Data changing – this permission allows adding, removing, editing table records.
Revoking permission to change data revokes permission to change table structure.
Permission to change table data can be granted only in the case if permission to change GDB data is given.
Search – gives a possibility to set condition of searching records when browsing a table and also to change conditions of getting cataloged queries built on the basis of this table.
Join – this permission allows setting joins between the present table and other tables and also changing the join scheme for cataloged queries including this table.
Calculations – this permission gives a possibility to create and remove calculated fields, performing total calculations when browsing this table.
Sorting – this permission allows changing condition of sorting records thus specifying the order of records when browsing the present table.
 |  |
