Preparing Teradata Server

Teradata server is prepared by the DBMS administrator.

Scripts are executed using any available method, for example, via the Teradata SQL Assistant application available on the Teradata official site.

Creating a Database User

The user is created using the script below that is executed in the DBMS front end:

CREATE USER USER_NAME FROM DBC AS PASSWORD=USER_PASSWORD PERM=1000000000 SPOOL=1000000000 DEFAULT DATABASE=USER_NAME DEFAULT CHARACTER SET UNICODE;

grant create procedure on DATABASE_NAME to USER_NAME;

where:

USER_NAME. Name of the created user (schema) that must correspond to the default database name.
USER_PASSWORD. Password for the created user (schema).
DATABASE_NAME. The database name where the created user is granted the permission to create procedures. It corresponds to the created user name.

After running the script successfully, move on to creating a repository.