17.10 - Example: Using ProfileInfoV - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

The following query lists the parameter settings of all profiles in the system together with their parameter settings:

SELECT CAST(ProfileName   AS CHAR(15)),
       CAST (DefaultDB    AS CHAR(15)),
       CAST (DefaultAccount AS CHAR(15)),
       SpoolSpace,
       TempSpace
FROM DBC.ProfileInfoV ORDER BY 1;
*** Query completed. 3 rows found. 5 columns returned.

Result:

ProfileName DefaultDB DefaultAccount SpoolSpace TempSpace
----------- --------- -------------- ---------- ------------
kanji       japan     i18n           50000      50000
HResources  personnel  ?               ?          ?
NTGroup     NT        ncrsandiego    50000      50000

If multiple accounts are specified for the ACCOUNT parameters, only the first account (the default account) in the list is reflected in the display. The remaining accounts in the list can be retrieved by performing a SELECT on the existing view DBC.AccountInfoV. Parameter settings for the profile assigned to the user may similarly be displayed by performing a SELECT on the system view DBC.ProfilesInfoVX.