This table holds the replicated data of tdrights.ini to be able to extract this information within reports. (e.g. USRGEN)
Transactions which want to use this information could integrate a call to SYSUSR.ReoSysUsr to update the table based on the current tdrights.ini content.
As the contents of tdrights.ini is defined once per userid this table is defined global.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| EXTKEY | User ID | Text | 8 | 1 | Edit | Yes | Public | ||
| NAM | User Name | Text | 40 | 1 | Edit | Yes | Public | ||
| PRF | Profile | Text | 16 | 1 | Edit | Yes | Public | ||
| UIL | Language | Text | 2 | 1 | Edit | Yes | Public | UILTXT | |
| STA | Status | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| DSG | Designer | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| ADM | Administrator | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| NOLCNT | Unsuccessful Retry Count | Numeric | 3 | 0 | Edit | Yes | Public | ||
| PWCDATTIM | Last Password Change | Datetime | 15 | 0 | Unknown | Yes | Public | ||
| PWEDATTIM | Date of Password Expiry | Datetime | 15 | 0 | Unknown | Yes | Public | ||
| LGIDATTIM | Last Login | Datetime | 15 | 0 | Unknown | Yes | Public | ||
| LGUDATTIM | Last unsuccessfull Login | Datetime | 15 | 0 | Unknown | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| SYSUSR_EXTKEY | EXTKEY | Unique |
/
EXTKEY
This is the technical short name used to identify a user within an installation. This user ID might be different to the user ID used to login to the application server. This depends on the used login mechanism and the environment.
This is the technical short name used to identify a user within an installation. This user ID might be different to the user ID used to login to the application server. This depends on the used login mechanism and the environment.
This is the long name of a user. This name is used to be shown in user selections and in any place, where a detailed name of a user is required.
This is the long name of a user. This name is used to be shown in user selections and in any place, where a detailed name of a user is required.
The profile assigned to the user within tdrights.ini. This might be the default profile of a user in case the user record holds a column PRF which defines a usually entity specific profile of the user.
The profile assigned to the user within tdrights.ini. This might be the default profile of a user in case the user record holds a column PRF which defines a usually entity specific profile of the user.
This language code defines the user interface language of the user.
This language code defines the user interface language of the user.
This field holds the loginstatus of the user. Depending on the history the user might be blocked or a password change might be requested.
This field holds the loginstatus of the user. Depending on the history the user might be blocked or a password change might be requested.
| Code | Text |
|---|---|
| 0 | Normal |
| 1 | Expired |
| 2 | Blocked |
This flag holds the designer property of the user. Within TradeDesign FatClient this property enables the use of the designmode to be able to change the application.
This flag holds the designer property of the user. Within TradeDesign FatClient this property enables the use of the designmode to be able to change the application.
| Code | Text |
|---|---|
| 0 | No Designer |
| 1 | Designer |
This flag holds the administrator property of the user. Within TradeDesign this property enables the use of the administration functions to be able to change the user profile and user rights.
This flag holds the administrator property of the user. Within TradeDesign this property enables the use of the administration functions to be able to change the user profile and user rights.
| Code | Text |
|---|---|
| 0 | No Administrator |
| 1 | Administrator |
This field holds the count of unsuccessfull logins since the last successfull login.
This field holds the count of unsuccessfull logins since the last successfull login.
This field holds the date and time when the password has been changed for the last time.
This field holds the date and time when the password has been changed for the last time.
This field holds the date and time when the password will expire or has expired. After expiry any login will request a password change.
This field holds the date and time when the password will expire or has expired. After expiry any login will request a password change.
This field holds the date and time when the user has logged in for the last time.
This field holds the date and time when the user has logged in for the last time.
This field holds the date and time when this userid has unsuccessfull tried to login in for the last time.
This field holds the date and time when this userid has unsuccessfull tried to login in for the last time.