Session Constraint Values for Directory Users - 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™
  • A directory user who is mapped to a permanent user inherits the permanent user privileges and constraint assignments.
  • A directory user who is not mapped to a permanent database user, but who uses Sign-On As to log on as a permanent user, inherits the user privileges and constraint assignments.
  • Directory users who are mapped to multiple constraint value sources (users or profiles) must use the user=user_name or profile=profile_name option in the logon string to specify the source for default constraint values and OVERRIDE privileges.
  • Directory users can use the SET SESSION CONSTRAINT option to access any mapped or inherited constraint assignments.
  • For directory users with no mappings and only PUBLIC or EXTUSER privileges, the session constraint value is NULL, and the user cannot access row level security tables.