Creating Compute Cluster Admins Using SQL | Teradata VantageCloud Lake - Creating Compute Cluster Administrators Using SQL

Creating Compute Cluster Admins Using SQL | Teradata VantageCloud Lake - Creating Compute Cluster Administrators Using SQL - Teradata Vantage

Teradata® VantageCloud Lake

Deployment

VantageCloud

Edition

Lake

Product

Teradata Vantage

Published

January 2023

Language

English (United States)

Last Update

2024-04-03

dita:mapPath

phg1621910019905.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

phg1621910019905

This administrator is responsible for administering compute groups, and providing users access to the groups. There can be more than one compute cluster administrator.

To create an administrator for VantageCloud Lake, do the following tasks:

Determine what to provision for the administrative profiles, roles and database administrators.
See User Privileges for commonly-assigned privileges for users.
Log on to VantageCloud Lake.
Go to Editor.
Connect as the database administrator, SYSDBA.
Create the profile for the compute cluster administrator using the following command. Best practice is to start the profile name with P_ to make it easily identifiable as a profile.
```
CREATE PROFILE P_profile_name AS COMPUTE GROUP = cluster_group ;
```
Create a role for the compute cluster administrator to use, if one has not been created, as follows. Best practice is to start the role name with R_ to make it easily identifiable as a role.
1. Create the role.
```
CREATE ROLE  R_role_name;
```
2. Assign privileges to the role.
```
GRANT privilege_list
ON database_object_name
TO role_name;
```
  The following is an example of the privileges:
```
GRANT CREATE COMPUTE GROUP TO R_role_name;
GRANT DROP COMPUTE GROUP TO R_role_name;
GRANT CREATE COMPUTE PROFILE TO R_role_name;
GRANT DROP COMPUTE PROFILE TO R_role_name;
```
See CREATE ROLE for additional information.

Create the compute cluster administrator. This procedure uses the administrator name ClusterDBA. Use a name that meets your company standards.

CREATE USER "ClusterDBA" FROM "DBC"
AS PERM = number_of_bytes
PASSWORD = temp_password
SPOOL = spool_size
NO BEFORE JOURNAL
NO AFTER JOURNAL;

Grant the role to the compute cluster administrator.
```
GRANT R_role_name TO ClusterDBA;
```
Log off as user SYSDBA.
Log in as ClusterDBA and change the password.