GRANT (Resource Pool)

Grants privileges on one or more resource pools to a database user or role. Once granted usage rights, users can switch to using the resource pool with ALTER USER (username) or with SET SESSION RESOURCE POOL.

Syntax

GRANT USAGE
   ON RESOURCE POOL resource-pool [, ...]
   TO { username | role | PUBLIC } [, ...]

Parameters

resource-pool

The resource pools on which to grant the privilege. 

{ username | role | PUBLIC } [,...]

The recipient of the procedure privileges, which can be one or more users, one or more roles, or all users and roles (PUBLIC).

  • username—Indicates one or more user names.
  • role—Indicates one or more roles.
  • PUBLIC—Indicates that all users and roles have granted privileges to the procedure.

Examples

This examples shows how to grant user Joe usage 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