17.00 - ACCOUNT - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

One or more accounts to be assigned to the user. See "Creating User Accounts" in Teradata Vantage™ - Database Administration, B035-1093.

Account strings defined in the user profile supersede the accounts defined in the user definition.

If you do not specify an account string for the user or the user profile, the user inherits the first account string that is defined for the immediate owner of the user, that is, another user or a database.

Users with multiple accounts can use one of the following methods to access a non-default account:

  • Logon string.
  • SET SESSION ACCOUNT statement.

For a user to specify an account in the logon string or in a SET SESSION ACCOUNT statement, the account must be assigned in the user or profile definition for the user.

account_string
Each position in an account string has a specific meaning and format requirement. See "Creating Account Strings" in Teradata Vantage™ - Database Administration, B035-1093. Each account_string must follow the Vantage object naming rules. See Teradata Vantage™ - SQL Fundamentals, B035-1141. You must enclose each account string with APOSTROPHE characters. You must separate each entry in a list of account strings with a COMMA character and enclose the list with LEFT PARENTHESIS and RIGHT PARENTHESIS characters.
Accounts do not exist independently in the database. Accounts only exist as specified in user, database, and profile definitions. You can specify the same account string in multiple object definitions, if needed.
The first account string you specify becomes the default account for the user, but you can specify multiple accounts if needed.