Query timeout syntax

You can specify a query timeout when you create a user or group. You can also alter the query timeout of a user or a group. Specify the query timeout in minutes.

Changes to the query timeout for the public group do not affect the admin user's settings.

  • To create a user with a query timeout, use the following syntax:
    CREATE USER username WITH QUERYTIMEOUT [number | UNLIMITED]
  • To create a group with a query timeout, use the following syntax:
    CREATE GROUP name WITH QUERYTIMEOUT [number | UNLIMITED]
  • To modify a user's query timeout, use the following syntax:
    ALTER USER username WITH QUERYTIMEOUT [number | UNLIMITED]
  • To modify a group's query timeout, use the following syntax:
    ALTER GROUP name WITH QUERYTIMEOUT [number | UNLIMITED]