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.
- 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.