gdbPermQueryAccess

Access to cataloged queries.

If access to queries is not permitted, a user is not allowed to perform the following operations:

Changing query structure.

Changing table data via queries.

Browsing queries.

Searching records in queries.

Joining tables in queries.

Calculations in queries.

Sorting.

This permission gives a user the ability to get a recordset of a query (the Recordset object) for queries of external databases. It is impossible to get a recordset of a query for not actual queries (the Query::IsActual property returns False).

gdbPermQueryChangeStructure

Changing cataloged query structure.

If changing query structure is not permitted, a user is not allowed to perform the following operations:

Cataloging new queries.

Removing queries.

Changing query structure.

Renaming queries.

This permission is always permitted for queries of external databases.

gdbPermQueryInsert

Adding records to a table through a recordset of a query.

This permission is entirely based on permission gdbPermQueryChangeData for GDB queries. You cannot change this permission using the User::SetQueryPermission method.

gdbPermQueryUpdate

Modifying fields in a table (possibly not all fields) through a recordset of a query.

This permission is entirely based on permission gdbPermQueryChangeData for GDB queries. You cannot change this permission using the User::SetQueryPermission method.

gdbPermQueryDelete

Removing records from a table through a recordset of a query.

This permission is entirely based on permission gdbPermQueryChangeData for GDB queries. You cannot change this permission using the User::SetQueryPermission method.

gdbPermQueryChangeData

Changing data in tables via a recordset of a query.

If changing data in queries is not permitted, a user is not allowed to perform the following operations:

Adding records to tables via queries.

Removing records from tables via queries.

Editing records in tables via queries.

gdbPermQuerySearch

Searching records in cataloged queries

This permission is always permitted for queries of external databases.

gdbPermQueryCalculate

Calculations in cataloged queries.

This permission is based on the ExternalDatabase::SupportCalculations property for queries of external databases.

gdbPermQueryJoin

Joining tables in cataloged queries.

This permission is always permitted for queries of external databases.

gdbPermQuerySort

Sorting records in cataloged queries.

This permission is always permitted for queries of external databases.