generated: 12.12.2016 18:34:55
by UC2010.accdb
AE Database 11.2 (Step 018)
| Name | Type | Len | Attributes | Description |
|---|---|---|---|---|
| USR_OH_Idnr | Long Integer | 4 | UC: Null=False | primary key |
| USR_Pw | Memo | 0 | UC: Typ=binary L=33 Null=False | password |
| USR_FirstName | Text | 20 | UC: Null=True | first name |
| USR_LastName | Text | 20 | UC: Null=True | last name |
| USR_Active | Byte | 1 | UC: Typ=Boolean Null=True | active flag (is the user active?) |
| USR_LastSession | Date/Time | 8 | UC: Null=True | date of last session |
| USR_SysMsg | Byte | 1 | UC: Typ=Boolean Null=True | is the user allowed to receive system messages? |
| USR_NoEdit | Byte | 1 | UC: Null=True | is the user allowed to change objects? |
| USR_Filter | Text | 255 | UC: Null=True | filter that is assigned to the user |
| USR_PwKey | Memo | 0 | UC: Null=True Typ=binary L=16 | encrypted password |
| USR_PwChange | Date/Time | 8 | UC: Null=True | date of last password change |
| USR_MultiLogon | Integer | 2 | UC: Null=True | how many parallel logins are allowed for this user? 0 = infinite |
| USR_EHRefresh | Integer | 2 | UC: Null=True | minimum refresh interval for activity refresh |
| USR_ValidTimeFrom | Date/Time | 8 | UC: Null=True | logon is allowed from |
| USR_ValidTimeTo | Date/Time | 8 | UC: Null=True | logon is allowed to |
| USR_CaleName | Text | 200 | UC: Null=True | logon is only allowed on days in this calendar |
| USR_CaleKeyName | Text | 200 | UC: Null=True | logon is only allowed on days in this calendar keyword |
| USR_Folder | Text | 200 | UC: Null=True | folder which is permanently mounted to the user |
| USR_AccessC0 | Byte | 1 | UC: Typ=Boolean Null=True | access to client 0 ? |
| USR_AccessC99 | Byte | 1 | UC: Typ=Boolean Null=True | access to client 99 ? |
| USR_Privilege | Long Integer | 4 | UC: Null=True L=8 | bit array for privileges |
| USR_EMail1 | Text | 50 | UC: Null=True | 1st e-mail address |
| USR_EMail2 | Text | 50 | UC: Null=True | 2nd e-mail address |
| USR_ErrorCnt | Long Integer | 4 | UC: Null=True | number of login errors |
| USR_Ldap | Byte | 1 | UC: Typ=Boolean Null=True | Is there an active LDAP connection for this user? (0=no, 1=yes) |
| USR_LdapUID | Memo | 0 | UC: Typ=binary L=255 Null=True | Unique UID of user in AD (objectGUID) |
| USR_Locked | Byte | 1 | UC: Typ=Boolean Null=True | Is the user locked? (0=no, 1=yes) |
| USR_DstngshdName | Memo | 0 | UC: Null=True L=1024 | AD distinguishedName for optimized access |
| USR_Login | Text | 200 | UC: Null=True | Name of Login-object |
| USR_Conn | Text | 200 | UC: Null=True | Name of Connection-object |
| USR_IgnoreSSO | Byte | 1 | UC: Typ=Boolean Null=True | 0: User is not allowed to ignore Kerberos, 1: User is allowed to ignore Kerberos |
Indexes:
| Name | Fields |
|---|---|
| PK_USR | USR_OH_Idnr |
Return to the Index File