Resource Pool Privileges

Only a superuser can create, alter, or drop a resource pool.

By default, users are granted USAGE rights to the GENERAL pool, from which their queries and other statements allocate memory and get their priorities. A superuser must grant users USAGE rights to any additional resource pools by using the GRANT USAGE ON RESOURCE POOL statement. Once granted access to the resource pool, users can use the SET SESSION RESOURCE_POOL statement and the RESOURCE POOL clause of the ALTER USER statement to have their queries draw their resources from the new pool.

Privilege Description
USAGE

Permission to use a resource pool.

SELECT

Permission to look up resource pool information/status in system tables.

UPDATE

Permission to adjust the tuning parameters of the pool.

For details on granting and revoking resource pool privileges, see GRANT (Resource Pool) and REVOKE (Resource Pool) in the SQL Reference Manual.