Using Profile to Set Default Query Band | Teradata Vantage - Using a Profile to Set a Default Query Band - Analytics Database - Teradata Vantage

Security Administration

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-04-05
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
lifecycle
latest
Product Category
Teradata Vantageā„¢

A default query band can be defined in a profile using the CREATE PROFILE statement. The profile query band can be used for tracking and controlling system usage, similar to the SET QUERY_BAND statement. The profile query band is automatically set for the session at logon time.

To assign the profile to a user, specify the profile name in the CREATE USER or MODIFY USER statement for the user.

The SET QUERY_BAND statement sets, updates, and removes the session and transaction query bands for the session. This statement does not affect the profile query band. The only way the profile query band changes for an existing session is if the profile for the session changes.

Use the MODIFY PROFILE statement to modify the profile query band. All profile query band changes to active sessions take effect at the beginning of the next request.

The profile query band is not saved in DBC.SessionTbl, so after a restart the session is initialized with the profile query band based on the current profile setting.

For information about the CREATE PROFILE and MODIFY PROFILE statements, see Teradata Vantageā„¢ - SQL Data Definition Language Syntax and Examples, B035-1144.