16.10 - SET QUERY_BAND Processing - Teradata Database

Teradata Database Security Administration

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
Administration
Security
Publication ID
B035-1100-161K
Language
English (United States)

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.