15.10 - ACCOUNT - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Add one or more accounts to any accounts already specified for the profile. See About Accounts.

For example: $M 0+account_ID &S&D&H

Each position in an account string has a specific meaning and format requirement. See Creating Account Strings.

account_string
Each account_string must follow the standard Teradata Database object naming rules, and must be enclosed by APOSTROPHE characters. Each entry in the account_string list must be separated by a COMMA character and enclosed by LEFT PARENTHESIS and RIGHT PARENTHESIS characters. See SQL Fundamentals, B035-1141.
On Teradata Database systems running on SLES 10, account strings include a character that defines the default priority level for use of system resources by sessions that run under the account; M in the example above.
On Teradata Database systems running on SLES 11, the priority character can be used to indicate a Viewpoint Workload Manager access level associated with the account, but the character does not in itself control the default priority.
Accounts do not exist independently in the database; they only exist as specified in user, database, and profile definitions. You can specify the same account string in multiple object definitions, if needed.
Account strings defined in the profile supercede the accounts defined in the user definitions of profile member users. Newly added accounts are immediately available.
The first account string specified for the profile is the default account for profile members.
If you do not specify an account string for a profile, the system defaults to the accounts specified for individual users. If a user has no account in either the user or profile definitions, the user inherits the first account string that is defined for the immediate owner of the user.
Users with multiple accounts can access a non-default account by specifying the account in:
  • The logon string.
  • A 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.