16.10 - Enabling Account String Expansion - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
April 2018
Content Type
Publication ID
English (United States)
Last Update

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 About the ASE Substitution Variables.