Using Profile to Set Default Query Band | Teradata Vantage - Using a Profile to Set a Default Query Band - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
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.