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 |