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 account string expansion variables. For more information, see Logging Resource Usage Data with Account String Variables
|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