Users who are allowed to manage compute profiles are compute profile administrators for a compute group. Users with this privilege can manage any compute profile in any or a selected compute group.
| Privilege | |
|---|---|
| Grant CREATE COMPUTE PROFILE privilege to the compute cluster administrator with grant option. This allows the administrator to grant CREATE COMPUTE PROFILE to other users. Because there is no ON clause, this is at the system level. | GRANT CREATE COMPUTE PROFILE TO ClusterDBA WITH GRANT OPTION;
|
| When specified with ON compute_group_name, the compute cluster administrator has CREATE COMPUTE PROFILE privilege for a compute group. | GRANT CREATE COMPUTE PROFILE ON compute_group_name TO ClusterDBA WITH GRANT OPTION; |
| Allow the compute cluster administrator to drop compute profiles. | GRANT DROP COMPUTE PROFILE TO ClusterDBA;
|
Example: Granting CREATE COMPUTE PROFILE Privileges to the Compute Cluster Administrator
- Log on as user DBC.
- Grant CREATE COMPUTE PROFILE privilege to the compute cluster administrator:
GRANT CREATE COMPUTE PROFILE TO ClusterDBA;
For grant statement syntax, see GRANT CREATE COMPUTE PROFILE.