GRANT (Resource Pool)
Grants privileges on resource pools to users and roles. After granted usage rights, users can access the resource pool with ALTER USER or SET SESSION RESOURCE POOL.
Syntax
GRANT USAGE ON RESOURCE POOL resource-pool[,…] TO grantee[,…] [ WITH GRANT OPTION ]
Parameters
USAGE | Enables grantees to acess the specified resource pools. |
ALL [PRIVILEGES] |
Grants all resource pool privileges that also belong to the grantor. Grantors cannot grant privileges that they themselves lack. The optional keyword |
resource-pool |
A resource pool on which to grant the specified privileges. |
grantee |
Specifies who is granted privileges, one of the following: |
WITH GRANT OPTION |
Gives grantee the privilege to grant the same privileges to other users or roles, and also revoke them. For details, see Granting Privileges. |
Privileges
Non-superuser: Privileges grantee given the option (WITH GRANT OPTION
) of granting privileges to other users or roles.
Examples
Grant user Joe
usage privileges on resource pool Joe_pool
.
=> CREATE USER Joe; CREATE USER
=> CREATE RESOURCE POOL Joe_pool; CREATE RESOURCE POOL
=> GRANT USAGE ON RESOURCE POOL Joe_pool TO Joe; GRANT PRIVILEGE