17.00 - Example: Using ProfileInfoV - Teradata Database

Teradata Vantage™ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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.