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