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