17.00 - ProfileInfoV[X] - 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

Category: Security

Database: DBC

View Column Data Type Format Comment
ProfileName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the profile.
DefaultAccount VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the default account, if any, for the user.
DefaultDB VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the default database.
SpoolSpace BIGINT --,---,---,---,---,---,--9 Returns an integer indicating the maximum spool space allowed for the database. SpoolSpace is 0 if DatabaseName is PUBLIC.
TempSpace BIGINT --,---,---,---,---,---,--9 Returns the maximum temporary space allocated for a database, profile, or user in bytes.
ExpirePassword SMALLINT ---,--9 Returns the number of days to elapse before the password expires. 0 indicates the password does not expire.
PasswordMinChar BYTEINT -(3)9 Returns the minimum number of characters in a valid password string.
PasswordMaxChar BYTEINT -(3)9 Returns the maximum number of characters in a valid password string. PasswordMaxChar must be equal to or greater than PasswordMinChar.
PasswordDigits CHAR(1) LATIN UPPERCASE X(1) Digits are allowed in the password string: Y/y (yes), N/n (no), R/r (at least one digit required).
PasswordSpecChar CHAR(1) LATIN UPPERCASE X(1) Returns a code to indicate which special characters are to be allowed in the password. For the definition of the codes, see DBC.SysSecDefaults.
PasswordRestrictWords CHAR(1) LATIN UPPERCASE X(1) Indicates whether to restrict certain words from being contained within a password string. These are the valid values: Y (Yes), N (No). The default is N.
MaxLogonAttempts BYTEINT -(3)9 Number of erroneous logons before the user is locked. 0 (user never locked).
LockedUserExpire SMALLINT ---,--9 Returns the number of minutes to elapse before a locked user is unlocked. 0 indicates immediate unlock. -1 indicates user is locked indefinitely.
PasswordReuse SMALLINT ---,--9 Returns the number of days to elapse before a password can be reused. 0 indicates immediate reuse.
CommentString VARCHAR(255) UNICODE NOT CASESPECIFIC X(255) Returns user-supplied text or commentary on the column, database, table, view, macro, user-defined function, user-defined types, user-defined methods, stored procedure, role, profile, or user.
CreatorName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Profile creator.
CreateTimeStamp TIMESTAMP(0) NOT NULL YYYY-MM-DDBHH:MI:SS Returns the date and time that the object in the row was created.
LastAlterName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the user who last updated the dictionary row.
LastAlterTimeStamp TIMESTAMP(0) NOT NULL YYYY-MM-DDBHH:MI:SS Returns the time the dictionary row was last updated.
Queryband VARCHAR(4096) UNICODE NOT CASESPECIFIC X(4096) The query band set at logon. NULL indicates that there is no profile query band.
QuerybandDefault CHAR(1) LATIN UPPERCASE X(1) A D indicates the names in the profile query band are default values. Default values can be set with different values in the session and transaction query bands. An R indicates the names are restricted and cannot be set to different values.
IgnoreQuerybandValues VARCHAR(4096) UNICODE NOT CASESPECIFIC X(4096) The ignore query band values. These name-value pairs will be discarded if found in a SET QUERY_BAND statement.
DefaultMapName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the default mapname for the profile. NULL indicates the profile does not have a default map.
MapOverride VARCHAR(1) LATIN NOT CASESPECIFIC X(1) MapOverride indicates no override or override on error for the default map. "N" indicates no override. "E" indicates OVERRIDE ON ERROR.