Create temporary user | Teradata Vantage - 2.2 - Creating a Test User - Teradata Vantage

Configuring Teradata Vantageā„¢ After Installation

Product
Teradata Vantage
Release Number
2.2
Release Date
January 2021
Content Type
Configuration
Implementation
Publication ID
B700-4014-011K
Language
English (United States)
Create a temporary user named Alex to test the configuration.
  1. Log on as SYSDBA.
  2. Create a test user called Alex, who is administered by SYSDBA, with a role of R_Batch_User, using the profile P_Batch_User, with 10 GB perm and 20 GB spool:
    CREATE USER Alex FROM SYSDBA AS DEFAULT ROLE=R_Batch_User, PROFILE=P_Batch_User,
    PERM=10E9, SPOOL=20E9, PASSWORD=password;
  3. Log off.