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. |