15.10 - ProfileInfoV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Security

DBC

 

View Column

Data Type

Format

Source Table.Column

ProfileName

VARCHAR(128)

UNICODE

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(128)

Profiles.ProfileName

DefaultAccount

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

Profiles.DefaultAccount

DefaultDB

VARCHAR(128)

UNICODE

X(128)

Profiles.DefaultDatabase

SpoolSpace

FLOAT

----,---,---,---,--9

Profiles.SpoolSpace

TempSpace

FLOAT

----,---,---,---,--9 (explicit)

Profiles.TempSpace

ExpirePassword

SMALLINT

---,--9 (explicit)

Profiles.ExpirePassword

PasswordMinChar

BYTEINT

--9 (explicit)

Profiles.PasswordMinChar

PasswordMaxChar

BYTEINT

--9 (explicit)

Profiles.PasswordMaxChar

PasswordDigits

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

X(1)

Profiles.PasswordDigits

PasswordSpecChar

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

X(1)

Profiles.PasswordSpecChar

PasswordRestrictWords

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

X(1)

Profiles.PasswordRestrictWords

MaxLogonAttempts

BYTEINT

---9 (explicit)

Profiles.MaxLogonAttempts

LockedUserExpire

SMALLINT

---,--9 (explicit)

Profiles.LockedUserExpire

PasswordReuse

SMALLINT

---,--9 (explicit)

Profiles.PasswordReUse

Queryband

VARCHAR(2048)

X(2048)

Profiles.Queryband

QuerybandDefault

CHAR(1)

X(1)

Profiles.QuerybandDefault

CommentString

VARCHAR(255)

UNICODE

NOT CASESPECIFIC

X(255)

Profiles.CommentString

CreatorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

Dbase.DatabaseName

CreateTimeStamp

TIMESTAMP(0)

NOT NULL

YYYY-MM-DDBHH:MI:SS

Profiles.CreateTimeStamp

LastAlterName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

Dbase.DatabaseName

LastAlterTimeStamp

TIMESTAMP(0)

NOT NULL

YYYY-MM-DDBHH:MI:SS

Profiles.LastAlterTimeStamp

In ProfileInfoV[X], if no profile is set up for the user or for ProfileInfo, and if no profile is defined, the view contains the following message:

No rows found

If the profile creator has been dropped, the ProfileInfoV[X] view contains the information of that profile, which is shown with the text "Dropped User" for CreatorName or LastAlterName.

Queryband

The Queryband column contains the profile query band string that is set in the user’s session at logon. NULL indicates that this profile option is not set.

Possible Values for QuerybandDefault

The value in this column indicates if the session or transaction query band can be set with the same name as in the profile query band.

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.