Create general user profiles | Teradata Vantage - 2.2 - Creating General User Profiles - 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 user profiles for general, update, and batch operations.

  1. Log on as SYSDBA.
  2. Create the general user profile P_General_User with the default database General_Views, 10 GB of spool space, and 0 bytes of temporary space. For example:
    CREATE PROFILE P_General_User AS
    DEFAULT DATABASE=General_Views, SPOOL=10e9, TEMPORARY=0;
  3. Create an update user profile P_Update_User with the default database Update_Views and 0 bytes of temporary space. For example:
    CREATE PROFILE P_Update_User AS
    DEFAULT DATABASE=Update_Views, TEMPORARY=0;
  4. Create a batch user profile P_Batch_User with 100 GB of spool space and 0 bytes of temporary space. For example:
    CREATE PROFILE P_Batch_User AS
    SPOOL=100e9, TEMPORARY=0;