SET SESSION SQL Statement | CREATE USER Option | Teradata Vantage - Example: Changing the Default Session Calendar Using CREATE USER - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

You can specify a different default session calendar for a user by specifying the SET SESSION CALENDAR SQL text string as the startup string for the user by submitting a CREATE USER or MODIFY USER statement.

Assuming that the default business calendar for the site is Teradata, the following CREATE USER statement creates a user named john_smith and uses the STARTUP string for john_smith to set his session calendar to COMPATIBLE instead of Teradata each time he starts a new session.

     CREATE USER john_smith AS
     PERM=10E6,
     PASSWORD=john_smith,
     SPOOL = 1200000,
     FALLBACK PROTECTION,
     STARTUP='SET SESSION CALENDAR=COMPATIBLE';