Category: Database
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Identifies a user. |
| CreatorName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The user who issued the CREATE USER statement. |
| PasswordLastModDate | DATE | YYYY/MM/DD | The date that the user password was last modified. |
| PasswordLastModTime | TIME(0) WITH TIME ZONE | HH:MI:SSZ | 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 total permanent space in bytes allocated to the user. |
| SpoolSpace | BIGINT | -(19)9 | An integer indicating the maximum spool space allowed for the database. SpoolSpace is 0 if DatabaseName is PUBLIC. |
| TempSpace | BIGINT | -(19)9 | The maximum temporary space allocated for a database, profile, or user in bytes. |
| ProtectionType | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Specifies 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) | The startup string (macro or SQL statement) specified for the user. |
| DefaultAccount | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The name of the default account, if any, for the user. |
| DefaultDataBase | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The name of the current default database for the user. |
| CommentString | VARCHAR(255) UNICODE NOT CASESPECIFIC | X(255) | Contains any user-supplied text for the user. |
| DefaultCollation | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | 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 | YYYY/MM/DD | The Julian date on which the current password was assigned to the user. This value is 0 for a new user. |
| LockedDate | DATE | YYYY/MM/DD | 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 | The TimeZone Hour offset from UTC. Valid range is -12 to +14. |
| TimeZoneMinute | BYTEINT | -(3)9 | The TimeZone Minute offset from UTC. Valid range is -59 to +59. |
| DefaultDateForm | CHAR(1) LATIN UPPERCASE | X(1) | Specifies 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 | The date and time that the object in the row was created. |
| LastAlterName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the user who last updated the dictionary row. |
| LastAlterTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The time the dictionary row was last updated. |
| DefaultCharType | SMALLINT | ---,--9 | The type of the user default character type. |
| RoleName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The name of a role. |
| ProfileName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The name of the profile. |
| AccessCount | BIGINT | --,---,---,---,---,---,--9 | The access count for the corresponding database object. |
| LastAccessTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The time that the corresponding object was last accessed. |
| ExportDefinitionName | VARCHAR(30) LATIN NOT CASESPECIFIC | X(30) | Name of the ExportWidthRuleSet for the user. A NULL value means to use the system defaults. |
| ExportWidthRuleSet | BYTE(20) | X(40) | 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) | Specifies if the user is DBA user or not. |
| TimeZoneString | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The time zone string set for a particular User. |
| DefaultMapName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | 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) | Indicates no override or override on error for the default map. "N" indicates no override. "E" indicates OVERRIDE ON ERROR. |
| DefaultComputeGroup | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The default compute cluster group name for the database or user. NULL indicates the database or user does not have a default compute group. |
| DefaultStorageName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The default Storage name for the database or user. NULL indicates the database or user does not have a default storage. |
| StorageOverride | CHAR(1) LATIN UPPERCASE | X(1) | Indicates no override or override on error for the default storage. "N" indicates no override. "E" indicates OVERRIDE ON ERROR. |
| AutoDBA | CHAR(1) | X(1) |
|
| AutoDBABits | BYTE(40) | X(80) | AutoDBA bits when the user is under AutoDBA control. Null when the user is under AutoDBA control. |