DBC.AccountInfoV - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-10-04
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

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