/ Access control / Chapter 87. Permissions to GDB and its components / Granting and revoking permissions to GDB and its componentsThe page “Queries” of the property sheet “Properties of user” is shown at figure 87-5.
Figure 87-5. Property sheet “Properties of user”, page “Queries”
A list of cataloged queries of the current GDB is given in the list pane. The checkbox General permissions to queries is shown at the figure in checked state, that is why checkboxes of permissions display general permissions with respect to all cataloged queries.
Access – this is the basic permission to queries providing inclusion of selected query into the list of queries of the current GDB.
If this permission is revoked for a particular query, its name will not be displayed in the list of cataloged queries for the present user. If this permission is revoked on the level of general permissions to all queries, type of components “Queries” will not be displayed in the tree of GDB structure for the current user.
This permission is closely connected with a similar permission for base tables of the present query. If the user has access to all base tables not only via queries, permission to the present query cannot be revoked for him. If he has no access even to one base table, he cannot have access to the query. Only in an intermediate case when the user has access to all query base tables, but has access only via queries at least to one of these tables, access to the present query can be either granted or revoked.
This permission has a higher level than other permissions to queries described below. Clearing the box Access leads to clearing remaining boxes.
Structure changing – this permission gives a possibility to change structure of selected cataloged query: show and hide fields, change displaying order of fields, change the scheme of joining tables, set and reset reference tables. Besides, this permission allows removing this cataloged query.
Absence of permission to change structure of the cataloged query does not prevent one from making changes in the structure when browsing a query if these changes do not contradict other permissions to a query and to the corresponding tables. But the user will not be able to save the changed query under the same name in this case. He can save changes as a new cataloged query, the source query will remain unchanged.
If permission to change structure has been revoked on the level of general permissions for all queries, creation of new cataloged queries is disabled including creation by saving the browsed query.
Permission to change query structure can be granted only in the case if permission to change GDB structure is granted. At the same time the user should not necessarily have permission to change structure of tables which are a part of the query since this structure is not changed.
If access only via queries is set at least for one of the base tables of the present query, permission to change query structure is revoked.
Data changing – this permission allows adding, removing, editing table records when browsing the present query.
If permission to change data is revoked for all base tables of the present query, it is revoked for the query as well. In other cases permission to change data for a query permits editing only those query fields which belong to base tables with enabled changing of data.
Search – gives a possibility to set condition of searching records when browsing a query and also to change conditions of getting a query.
If this query is built by joining several tables, permission to searching for a query allows changing only the simple search conditions which use fields from base tables for which search permission is also granted. If this permission is revoked for all base tables, it is revoked for the query as well.
Join – this permission allows changing the join scheme of base tables for the present query.
If the query is built by joining several tables, permission to joins allows adding and removing from the join scheme only the base tables for which permission to joins is also granted. If this permission is revoked for all base tables, it is revoked for the query as well.
Calculations – this permission gives a possibility to create and remove calculated fields, performing total calculations when browsing this query.
If the query is built by joining several tables, permission to calculations allows setting and resetting calculations only with fields of those base tables for which permission to calculations is also given. If this permission is revoked for all base tables, it is revoked for the query as well.
Sorting – this permission allows changing condition of sorting records thus specifying the order of records when browsing the present query.
If permission to sorting is revoked for all base tables, it is revoked for the query as well.
 |  |
