Granting Access to Compute Groups Using SQL | Teradata VantageCloud Lake - Granting Access to Compute Groups Using SQL

Granting Access to Compute Groups Using SQL | Teradata VantageCloud Lake - Granting Access to Compute Groups 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

The compute cluster administrator grants access to the compute group to users.

Log on to VantageCloud Lake.
Go to Editor.
Connect as the database administrator, SYSDBA.

Create a profile to be used by the user, if one has not been created. Best practice is to start the profile name with P_ to make it easily identifiable as a profile.

CREATE PROFILE P_profile_name AS profile ;

The following is an example with profile attributes shown in bold:

CREATE PROFILE P__profile AS
COMPUTE GROUP = COMPUTE
SPOOL=spool_space,
TEMPORARY=NULL,
ACCOUNT=('account__strA',' account_strB'),
DEFAULT DATABASE="All",
PASSWORD =
(EXPIRE=90,MINCHAR=NULL,MAXCHAR=NULL,MAXLOGONATTEMPTS=NULL,
LOCKEDUSEREXPIRE=NULL,REUSE=NULL,DIGITS=NULL,
RESTRICTWORDS=NULL,SPECCHAR=NULL);

See CREATE PROFILE for additional information.

Create a role to be used by the user, if one has not been created, as follows. The group name is automatically appended as part of the role name.
1. Create the role. Best practice is to start the role name with R_ to make it easily identifiable as a role.
```
CREATE ROLE R_compute_group_role;
```
2. Assign privileges to the role.
```
GRANT COMPUTE GROUP cluster_group
TO R_compute_group_role;
```
See CREATE ROLE for additional information.
Grant the user access to the compute group.
```
GRANT COMPUTE GROUP = cluster_group TO user_name;
```
See CREATE USER for additional information.

Grant the role to the user.

GRANT R_compute_group_role TO user_name;