About DBC.AccountInfoV - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

About DBC.AccountInfoV

The DBC.AccountInfoV view accesses the DBC.Dbase, DBC.Profiles, and DBC.Accounts dictionary tables to return information about all valid accounts for all databases, users, and profiles.

Use DBC.AccountInfoV to find out:

  • What accounts are valid for which user
  • The assignment of:
  • Priority Scheduling codes
  • Account string expansion variables (see “Logging Resource Usage Data with Account String Variables” on page 160).

    This dictionary table …

    Stores …


    all accounts for all databases, users, and profiles.

    If an account is not specified at creation time, the default is used. The default is determined as explained in “Determining the Account for a User Session” on page 108.

    DBC.Accounts is used to verify any account entered by a user at logon time or with a SET SESSION ACCOUNT statement.


    the default account for each:

  • Database
  • User
  • If a database or user is defined with multiple accounts, the first is used as the default.

    If a user is assigned a profile that is defined with one or more accounts, the first profile account is used as the default. (Profile accounts take precedence over user accounts.)


    the default account for each profile. If multiple accounts are defined, the first is used.

    Note: If an account is not specified for a profile, the value is NULL in the DefaultAccounts field for that profile.


    The following query selects all account strings with a RUSH priority code, and whether the name associated with an account is an individual user or a profile:

    SELECT AccountName,UserName,UserOrProfile
    FROM DBC.AccountInfoV
    WHERE AccountName LIKE '$R%'
    ORDER BY AccountName ;

    In this example, the view returns: