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]