Category: Security
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| ProfileName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the profile. |
| DefaultAccount | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The name of the default account, if any, for the user. |
| DefaultDB | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The name of the default database. |
| SpoolSpace | BIGINT | --,---,---,---,---,---,--9 | An integer indicating the maximum spool space allowed for the database. SpoolSpace is 0 if DatabaseName is PUBLIC. |
| TempSpace | BIGINT | --,---,---,---,---,---,--9 | Maximum temporary space allocated for a database, profile, or user in bytes. |
| ExpirePassword | SMALLINT | ---,--9 | Number of days to elapse before the password expires. 0 indicates the password does not expire. |
| PasswordMinChar | BYTEINT | -(3)9 | Minimum number of characters in a valid password string. |
| PasswordMaxChar | BYTEINT | -(3)9 | 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) | 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 | Number of minutes to elapse before a locked user is unlocked. 0 indicates immediate unlock. -1 indicates user is locked indefinitely. |
| PasswordReuse | SMALLINT | ---,--9 | Number of days to elapse before a password can be reused. 0 indicates immediate reuse. |
| CommentString | VARCHAR(255) UNICODE NOT CASESPECIFIC | X(255) | The user-supplied text or commentary on the column, database, table, view, macro, user-defined function, 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 | The date and time that the object in the row was created. |
| LastAlterName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The name of the user who last updated the dictionary row. |
| LastAlterTimeStamp | TIMESTAMP(0) NOT NULL | YYYY-MM-DDBHH:MI:SS | 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 are discarded if found in a SET QUERY_BAND statement. |
| DefaultMapName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The default mapname for the profile. NULL indicates the profile 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 or the profile. Null indicates the profile does not have a default compute cluster group. |
| DefaultStorageName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The default Storage for users assigned this profile. Null indicates the profile 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 profile is under AutoDBA control. Null when the profile is under AutoDBA control. |