16.20 - Using SET SESSION CONSTRAINT To Modify the Constraints Assigned to You for the Current Session - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

Several possible uses exist for using a SET SESSION CONSTRAINT request to alter the row-level security constraints in effect for the session. The noted changes can be applied whether the default row-level security constraint set for the session was assigned to a user or to a profile. The following points indicate some of the possible uses for a SET SESSION CONSTRAINT request.

  • To change the default level (hierarchical) constraint for a session.
  • To change the active category (non-hierarchical) constraint set for a session to a subset of those defined for the constraint.