Example: Creating User Using TIME ZONE=’time_zone_string’ - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

This example creates user_name with a default time zone displacement defined by the text string 'America Pacific'. When user_name is created, Vantage passes the time zone string to a system-defined UDF that validates it. The UDF is also called to retrieve the rules associated with the time zone string whenever user_name logs on.

If the value of the time_zone_string you specify is not valid, the system returns an error to the requestor.

     CREATE USER user_name 
     FROM r_n_d AS
     PERMANENT = 1000000,
     PASSWORD = abbub279,
     SPOOL = 1200000,
     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 = 'America Pacific';