Enable Account String Expansion | Teradata Vantage - Enabling Account String Expansion - Analytics Database - Teradata Vantage

Database 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
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

Before a user can activate any of the ASE functions, there must be a matching account string in the DBC.UsersV view for that user and ASE function. This means that the user cannot simply add the ASE variables to any logon account string unless first authorized by the DBA. This permits a level of control over users and programmers who may or may not use ASE properly.

For example, to create a user that can use ASE, define the variables in his account string or the profiles that he will use.

The DBA or any user with CREATE USER privileges can define the following:

CREATE USER john FROM finance AS PERM = 100000, ACCOUNT = '$H00MSIR&D&H', '$M00MSIR&D&H';

While the recommended ASE variable combination is &D&H, others include time (&T) and the time of log on (&L), or a combination thereof. Teradata no longer recommends use of the session variable (&S). For more information on the different variables, see ASE Substitution Variables.