Before a user can activate ASE functions, there must be a matching account string in the DBC.UsersV view for that user and ASE function. A user cannot add the ASE variables to a logon account string unless first authorized by the DBA. This gives the DBA control over users who may use ASE properly.
For example, to create a user that can use ASE, define the variables in their account string or their profiles.
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). See ASE Substitution Variables.