16.10 - About DBC.AccountInfoV - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

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:

Dictionary Table What It Stores
DBC.Accounts All accounts for all databases, users, and profiles.

If an account is not specified at creation time, the default is used.

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

DBC.DBase The default account for each database and 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.)

DBC.Profiles The default account for each profile. If multiple accounts are defined, the first is used.
If an account is not specified for a profile, the value is NULL in the DefaultAccounts field for that profile.

Example SELECT on DBC.AccountInfoV

The following query selects all account strings with a Timeshare Top 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:

AccountName        UserName           UserOrProfile
--------------     --------------     --------------
$R1$ABCD&D&H     AcctsRecv          Profile
$R1$EFGH&D&H     DBADMIN            User
$R2$IJKL&D&H     DBC                User
$R2$MNOP&D&H     SysAdmin           User
$R2&QRST&D&H     SystemFe           User