Specifying SQL Verbs resource limits

The SQL Verbs resource limits specify the SQL verbs that you are allowed to use when the current 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