16.20 - Example: Using ProfileInfoV - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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.