17.10 - Example: Creating New User With EXPECTED Export Width Table Name - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

This example creates a new user who is defined using the EXPECTED export width definition.

     CREATE USER fc1
     FROM r_n_d AS
     PERMANENT = 1000000,
     PASSWORD = bub279,
     SPOOL = 2200000,
     FALLBACK PROTECTION,
     DUAL AFTER JOURNAL,
     DEFAULT JOURNAL TABLE = r_n_d.journals,
     DEFAULT DATABASE = r_n_d,
     STARTUP = 'EXEC setpf;'
     ACCOUNT = '$mr_n_d','$hr_n_d',
     TIME ZONE = 'Africa Egypt'
     EXPORTWIDTH = EXPECTED;