Resetting the Session Constraint - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2022-02-15
dita:mapPath
ppz1593203596223.ditamap
dita:ditavalPath
wrg1590696035526.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantage™

Users have the option to change the default constraint values available for a session using the SET SESSION CONSTRAINT statement.

Based on Example: Loading Tables without User OVERRIDE Privileges, U1 might reset the session default Countries constraint:

SET SESSION CONSTRAINT = Countries (UK, Canada);

The session constraint value is changed from the ‘E0’xb shown above to '60'xb (hex representation of 01100000). Subsequent inserts during the session default to '60'xb for the Countries constraint column.

You can display the hex string for the default constraint values using the HELP SESSION CONSTRAINT statement.