17.20 - Session Constraint Values for Trusted User Applications and Proxy Users - Analytics Database - Teradata Vantage

Teradata Vantage™ - Analytics Database Security Administration - 17.20

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
2023-03-07
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
If the trusted user application submits an initial SET QUERY_BAND statement (a standard operation for trusted user applications) the system resets the session constraint values to an empty set, and takes the following actions:
  • If the statement does not set a proxy user, the session uses the default constraint value for the trusted user according to the normal permanent user constraint hierarchy. See Session Constraint Values for Permanent Database Users.
  • If the statement sets a proxy user, and the user is also a permanent database user, the system uses the default constraint value for the permanent user, according to the normal permanent user constraint hierarchy, including profile. See Session Constraint Values for Permanent Database Users.
  • If the application proxy user does not have a profile or the profile has no security constraint, the system is unable to set a session constraint value and also will not accept a SET SESSION CONSTRAINT statement. If the application proxy user has a profile with a security constraint, the session is set to that constraint.