Granting Users Access to Compute Groups - Teradata VantageCloud Lake

To use compute cluster resources, a user is associated with a compute group.

A user can be created with a default compute cluster association or an existing user can be modified to have a compute group.

Example: Create a New User with a Compute Group

create user user_name as 
password = user_password
perm=1e8
default database = user_name
COMPUTE GROUP = compute_group_name;

And grant the user access privilege to the group:

GRANT COMPUTE GROUP ON compute_group_name TO user_name

Example: Modify a User to Allow Access to a Compute Group

modify user user_name as COMPUTE GROUP = compute_group_name;

And grant the user access privilege to the group:

GRANT COMPUTE GROUP ON compute_group_name TO user_name

Additional Information

See Setting Up Compute Cluster Administrative Users - SQL Examples.