17.00 - Usage Notes - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

During a session, the account name may be changed. For the current account name of the session, see SessionInfoV[X].

For information about the possible values for the JournalFlag column, see "JournalFlag Column."

UserName

For this column, the SYSTEMUSERID is a system user name that tracks console utility activity such as table rebuild or Scandisk.

Possible Values for DefaultCharType

Value Description
1 Latin
2 Unicode
3 KanjiSJIS
4 Graphic
5 Kanji1

Possible Values for DefaultCollation

Value Description
A ASCII
E EBCDIC
H Host
M Multinational
C CharSet_Coll
J JIS_Coll

Possible Value for DefaultDataBase

If the default database is not defined in a CREATE/MODIFY USER statement, the DefaultDataBase column is the user space and NULL is returned.

At logon, the DefaultDataBase column may be superseded by a default account in a profile, if the user has a profile that specifies a default account.