generated: 09.12.2016 10:29:12
by UC2010.accdb
AE Database 12.0 (Step 013)
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