Creating a user on Teradata - 7.1

Talend Data Management Platform Studio User Guide

EnrichVersion
7.1
EnrichProdName
Talend Data Management Platform
EnrichPlatform
Talend Studio
task
Design and Development
You must create a Teradata user with CREATE FUNCTION and EXECUTE FUNCTION access rights.

Procedure

  1. Login to Teradata using dbc as username and password.
  2. Create a user. You can use the following command:
    CREATE user test AS password=test perm = 200000000, SPOOL = 100000000;
  3. Grant the user you created at least the CREATE FUNCTION and EXECUTE FUNCTION access rights.