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.