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:

After running the script successfully, proceed to creating a repository.

See also:

Preparing DBMS Back End