DB2 graphic  QMF Version 8

SQL Verbs

Use the SQL page to specify the SQL verbs that users assigned to this resource limits group are allowed to use when this schedule is in effect.

If a user tries to run a query that contains a disallowed verb, QMF for Windows cancels the query without sending the SQL to the database server. If a user attempts to run a query that contains an allowed verb, QMF for Windows sends the query to the database server and the database server's security authorization validation takes place.

Note:
Turning off the permissions for UPDATE, DELETE and INSERT does not affect the ability to perform these actions using the table editor.

You can allow one or more of the following SQL verbs from QMF for Windows:

Table 20. SQL Verbs that can be controlled
ACQUIRE ALTER CALL
COMMENT CREATE DELETE
DROP EXPLAIN GRANT
INSERT LABEL LOCK
REVOKE SET SELECT
SIGNAL UPDATE


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004