15.10 - Using SET SESSION CONSTRAINT To Modify the Constraints Assigned to You for the Current Session - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
December 2015
Content Type
Programming Reference
Publication ID
English (United States)

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.