| Privilege | |
|---|---|
| Grant CREATE COMPUTE GROUP privilege to the compute cluster administrator with grant option. This allows the administrator to grant CREATE COMPUTE GROUP to other users. The compute_group_name must be an existing compute group.
|
GRANT CREATE COMPUTE GROUP compute_group_name TO ClusterDBA WITH GRANT OPTION; |
| Allow the compute cluster administrator to drop compute groups. Any compute profilesassociated with the compute groups must be dropped first.
|
GRANT DROP COMPUTE GROUP TO ClusterDBA;
|
Example: Granting COMPUTE GROUP Privileges to the Compute Cluster Administrator
- Log on as user DBC.
- Grant COMPUTE GROUP privilege to the compute cluster administrator and allow the compute cluster administrator the ability to grant COMPUTE GROUP to other users using the WITH GRANT OPTION clause:
GRANT CREATE COMPUTE GROUP TO ClusterDBA WITH GRANT OPTION;
For grant statement syntax, see GRANT CREATE COMPUTE GROUP.