Use the Options page to specify levels of access users have to the database objects and the database server.
Field | Description |
---|---|
Allow access to server from user interface | Users assigned to this resource limits group can access the database server using QMF for Windows. |
Allow access to server from programming interface | Users assigned to this resource limits group can access the database server using the QMF for Windows application programming interface (API). |
Fetch all rows automatically | Determines how the database server sends query
results to QMF for Windows. QMF for Windows typically requests data
from the database server only as required to display query results.
For example, if 20 rows fill up the query window, QMF for Windows requests only 20 rows. When the user scrolls down to view the 21st row, QMF for Windows requests more data. If the user runs the query and then waits before scrolling down, the query remains active for that wait time. This consumes resources at the database server while the query is active. If you enable this parameter, QMF for Windows requests data repeatedly until it receives all data, independent of the user's scrolling requests. |
Confirm database updates | Determines whether QMF for Windows prompts the
user to confirm database changes resulting from the queries they run
or the actions they perform when editing tables.
Enable this option if you want QMF for Windows to prompt users to confirm database changes. Disable this option if you want database changes to be made without confirmation. |
Allow exporting of data | Permits use of the Export Data command on the File menu or in procedures. |
Allow table editing | Permits the use of the table editor with QMF for Windows. |
Allow running of saved queries only | When checked, this parameter limits the user to only running queries that have been saved at the database server. The user cannot create or save new queries at the database server. |
Isolation Level for Queries | Sets the isolation level for queries run by users.
This option applies to the following types of servers:
|
Account | Sets the default string for accounting information being sent to the database server when users in the resource limits group connect to it. |
Account can be overridden | Allows the user to override the default account
by entering a new account string on the Set User Information dialog
box.
Uncheck this check box if this resource limits group should be prevented from accessing database objects that are not owned by the group. |
Account must be specified | When selected, requires the user to specify a valid accounting string. |