| USR_OH_Idnr |
int |
NUMBER(38,0) |
int |
false |
primary key |
| USR_Pw |
varbinary(33) |
RAW(33) |
varchar(33) for bit data |
false |
password |
| USR_FirstName |
varchar (20) |
VARCHAR2 (20 CHAR) |
varchar(20) |
true |
first name |
| USR_LastName |
varchar (20) |
VARCHAR2 (20 CHAR) |
varchar(20) |
true |
last name |
| USR_Active |
smallint |
NUMBER(38,0) |
smallint |
true |
active flag (is the user active?) |
| USR_LastSession |
datetime |
DATE |
timestamp |
true |
date of last session |
| USR_SysMsg |
smallint |
NUMBER(38,0) |
smallint |
true |
is the user allowed to receive system messages? |
| USR_NoEdit |
smallint |
NUMBER(38,0) |
smallint |
true |
is the user allowed to change objects? |
| USR_Filter |
varchar (255) |
VARCHAR2 (255 CHAR) |
varchar(255) |
true |
filter that is assigned to the user |
| USR_PwKey |
varbinary(16) |
RAW(16) |
varchar(16) for bit data |
true |
encrypted password |
| USR_PwChange |
datetime |
DATE |
timestamp |
true |
date of last password change |
| USR_MultiLogon |
smallint |
NUMBER(38,0) |
smallint |
true |
how many parallel logins are allowed for this user? 0 = infinite |
| USR_EHRefresh |
smallint |
NUMBER(38,0) |
smallint |
true |
minimum refresh interval for activity refresh |
| USR_ValidTimeFrom |
datetime |
DATE |
timestamp |
true |
logon is allowed from |
| USR_ValidTimeTo |
datetime |
DATE |
timestamp |
true |
logon is allowed to |
| USR_CaleName |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
logon is only allowed on days in this calendar |
| USR_CaleKeyName |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
logon is only allowed on days in this calendar keyword |
| USR_Folder |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
folder which is permanently mounted to the user |
| USR_AccessC0 |
smallint |
NUMBER(38,0) |
smallint |
true |
access to client 0 ? |
| USR_AccessC99 |
smallint |
NUMBER(38,0) |
smallint |
true |
access to client 99 ? |
| USR_Privilege |
bigint |
NUMBER(38,0) |
bigint |
true |
bit array for privileges |
| USR_EMail1 |
varchar (50) |
VARCHAR2 (50 CHAR) |
varchar(50) |
true |
1st e-mail address |
| USR_EMail2 |
varchar (50) |
VARCHAR2 (50 CHAR) |
varchar(50) |
true |
2nd e-mail address |
| USR_ErrorCnt |
int |
NUMBER(38,0) |
int |
true |
number of login errors |
| USR_Ldap |
smallint |
NUMBER(38,0) |
smallint |
true |
Is there an active LDAP connection for this user? (0=no, 1=yes) |
| USR_LdapUID |
varbinary(255) |
RAW(255) |
varchar(255) for bit data |
true |
Unique UID of user in AD (objectGUID) |
| USR_Locked |
smallint |
NUMBER(38,0) |
smallint |
true |
Is the user locked? (0=no, 1=yes) |
| USR_DstngshdName |
varchar(1024) |
VARCHAR2 (1024 CHAR) |
varchar(1024) |
true |
AD distinguishedName for optimized access |
| USR_Login |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Name of Login-object |
| USR_Conn |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Name of Connection-object |
| USR_IgnoreSSO |
smallint |
NUMBER(38,0) |
smallint |
true |
0: User is not allowed to ignore Kerberos, 1: User is allowed to ignore Kerberos |