Skip to content

ON CLUSTER

Syntax

GRANT USAGE 
   ON CLUSTER cluster_name [, ...]
   TO role_specification [, ...] [ WITH GRANT OPTION ]

Privilege to use one or more clusters in an instance for queries and other database operations. This privilege is checked when the USE CLUSTER statement is run, and whenever a query plan is sent to the Yellowbrick database (backend). Users must be granted this privilege in order to connect to a data warehouse instance and run queries or database commands.

Example

Grant USAGE on a specific cluster to a specific user:

premdb=# grant usage on cluster "bobr-rc5-april4-cluster" to jamesbond;
GRANT