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 PRIVILEGES conforms with the SQL standard.

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

See Also