17.00 - UsersV - 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: Database

Database: DBC

View Column Data Type Format Comment
UserName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) The UsersV.Username field identifies a user.
CreatorName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the Teradata user who issued the CREATE USER statement.
PasswordLastModDate DATE YY/MM/DD Returns the date that the user password was last modified.
PasswordLastModTime TIME(0) HH:MI:SS Returns the time that the user password was last modified.
OwnerName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) User owner name.
PermSpace BIGINT NOT NULL --,---,---,---,---,---,--9 The UsersV.PermSpace field specifies the total permanent space in bytes allocated to the user.
SpoolSpace BIGINT -(19)9 Returns an integer indicating the maximum spool space allowed for the database. SpoolSpace is 0 if DatabaseName is PUBLIC.
TempSpace BIGINT -(19)9 Returns the maximum temporary space allocated for a database, profile, or user in bytes.
ProtectionType CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns F (Fallback) or N (None) to indicate whether the tables in the database are protected by the Fallback option.
JournalFlag CHAR(2) LATIN UPPERCASE NOT NULL X(2) Journaling in effect for the table, or the journal default for tables. Settings: first character BEFORE, second character AFTER.
StartupString VARCHAR(255) UNICODE NOT CASESPECIFIC X(255) Returns the startup string (macro or SQL statement) specified for the user.
DefaultAccount VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the default account, if any, for the user.
DefaultDataBase VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the current default database for the user.
CommentString VARCHAR(255) UNICODE NOT CASESPECIFIC X(255) The UsersV.CommentString field contains any user-supplied text for the user.
DefaultCollation CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns the default collation for the user as defined in a CREATE/MODIFY USER statement; if not defined, the DefaultCollation is the collation of the logon client system.
PasswordChgDate DATE YY/MM/DD Returns the Julian date on which the current password was assigned to the user. This value is 0 for a new user.
LockedDate DATE yy/mm/dd Returns the Julian date on which the Dbase row was locked to logons due to excessive erroneous passwords. A null or 0 value indicates the row was never locked.
LockedTime INTEGER 99:99 Minutes after midnight when the row was locked to logons due to excessive erroneous passwords. NULL or zero (row never locked)
LockedCount BYTEINT -(3)9 Number of successive unsuccessful attempts to logon to the user with an erroneous password. NULL or zero (no attempts).
TimeZoneHour BYTEINT -(3)9 Returns the TimeZone Hour offset from UTC. Valid range is -12 to +14.
TimeZoneMinute BYTEINT -(3)9 Returns the TimeZone Minute offset from UTC. Valid range is -59 to +59.
DefaultDateForm CHAR(1) LATIN UPPERCASE X(1) Returns either an INTEGERDATE or ANSIDATE that is set for a USER with the CREATE or MODIFY statement.
CreateTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the date and time that the object in the row was created.
LastAlterName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the user who last updated the dictionary row.
LastAlterTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the time the dictionary row was last updated.
DefaultCharType SMALLINT ---,--9 Returns the type of the user default character type.
RoleName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of a role.
ProfileName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the profile.
AccessCount BIGINT --,---,---,---,---,---,--9 Returns the access count for the corresponding database object.
LastAccessTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the time that the corresponding object was last accessed.
ExportDefinitionName VARCHAR(30) LATIN NOT CASESPECIFIC X(30) The ExportDefinitionName is the name of the ExportWidthRuleSet for the user. A NULL value means to use the system defaults.
ExportWidthRuleSet BYTE(20) X(40) The ExportWidthRuleSet is the export width rule set associated with the ExportDefinitionName and is updated if this association changes. A NULL value means to use the system defaults.
DBA CHAR(1) LATIN UPPERCASE NOT NULL X(1) The UsersV.DBA column specifies if the user is DBA user or not.
TimeZoneString VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the time zone string set for a particular User.
DefaultMapName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the default map name for the database or user. NULL indicates the database or user 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.