Specifying SQL Verbs resource limits

On the SQL Verbs page of the Edit Resource Limits Group Schedule window you 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, the query is canceled without sending the SQL to the data source. SQL Verbs resource limits can be set for data sources.

The use of the following SQL verbs can be controlled:
  • ACQUIRE
  • ALTER
  • CALL
  • COMMENT
  • CREATE
  • DELETE
  • DROP
  • EXPLAIN
  • GRANT
  • INSERT
  • LABEL
  • LOCK
  • REFRESH
  • RENAME
  • REVOKE
  • SET
  • SELECT
  • UPDATE