16.20 - UsersV - 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

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.
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 errror for the default map. "N" indicates no override. "E" indicates OVERRIDE ON ERROR.