The users are stored in the JRUSERS table. Primary key is the user name. Users can be added by adding a new row to this table.
The structure of the table:
Column name |
Data type |
Description |
|---|---|---|
username |
(N)VARCHAR(50) |
User name |
(N)VARCHAR(100) |
Email address |
|
password |
(N)VARCHAR(50) |
Password hash |
title |
(N)VARCHAR(50) |
Not used |
lastname |
(N)VARCHAR(50) |
Last name |
prename |
(N)VARCHAR(50) |
First name |
department |
(N)VARCHAR(50) |
Department |
phone |
(N)VARCHAR(50) |
Telephone |
fax |
(N)VARCHAR(50) |
Fax |
supervisor |
(N)VARCHAR(50) |
Supervisor |
admin_rights |
INTEGER |
Flag administrator rights 1: On 0: Off |
manage_users |
INTEGER |
Flag user management rights 1: On 0: Off |
manage_user_profiles |
INTEGER |
Flag user profiles management rights 1: On 0: Off |
manage_jobs |
INTEGER |
Flag Job Function management rights 1: On 0: Off |
manage_processes |
INTEGER |
Flag process management rights 1: On 0: Off |
manage_tables |
INTEGER |
Flag JobData tables management rights 1: On 0: Off |
access_webservice |
INTEGER |
Flag web service access 1: On 0: Off |
configuration |
INTEGER |
Flag configuration rights 1: On 0: Off |
login_count |
INTEGER |
Number of logins |
last_login |
DATETIME |
Date of the last login |
last_password_change |
DATETIME |
Date of the last password change |
notification |
INTEGER |
Flag email notification
The value is a bit mask. The individual options are assigned as follows: 0: Off 2: new steps 4: Requests/Answers 8: Assignments
Examples in the column: 14: All notifications enabled 12: Requests/Answers and Assignments 10: Notifications for new steps and assignments 6: Notifications for new steps and requests/answers |
summarized_notification |
INTEGER |
Flag Summarized Notification rights 2: Notify only if new steps are available 1: On 0: Off |
last_summarized_notification |
DATETIME |
Date of the last summarized notifications sent |
winlogin |
(N)VARCHAR(50) |
Username for NTLM login |
representation |
INTEGER |
Flag right to choose substitute 1: On 0: Off |
inbox_refresh |
INTEGER |
Not used |
start_dialog |
(N)VARCHAR(50) |
Start dialog |
new_window |
INTEGER |
Steps will be opened in a new window |
user_language |
(N)VARCHAR(50) |
Language of the user |
number_of_lines |
INTEGER |
Number of entries displayed per page in an inbox |
blocked |
INTEGER |
Flag user blocked 1: User is blocked 0: User is active |
false_login_count |
INTEGER |
Number of failed logins |
must_change_password |
INTEGER |
Flag password change required 1: Password must be changed 0: No action |
userprofile |
INTEGER |
User Profiles |
jobrouter_administration |
INTEGER |
Flag automatic/manual creation 1: User was created/managed manually in JobRouter 0: User was created/managed automatically by JobServer |
admin_monitor |
INTEGER |
Flag access admin monitor: 1: Access allowed 0: No access |
admin_log_notification |
INTEGER |
Flag notification about errors in the admin log: 1: On 0: Off |
user_defined1 |
(N)VARCHAR(255) |
User defined field 1 |
user_defined2 |
(N)VARCHAR(255) |
User defined field 2 |
user_defined3 |
(N)VARCHAR(255) |
User defined field 3 |
user_defined4 |
(N)VARCHAR(255) |
User defined field 4 |
user_defined5 |
(N)VARCHAR(255) |
User defined field 5 |
avatar |
(N)VARCHAR(255) |
Internal name of the avatar file |
manage_substitutions |
INTEGER |
Flag substitute administration 1: User is allowed to activate/deactivate substitution 0: off |
substitution_status |
INTEGER |
Flag substitution active 1: Substitution active 0: Substitution inactive |
date_format |
INTEGER |
Date Format 1: DD.MM.YYYY 2: DD/MM/YYYY 3: MM/DD/YYYY 4: YYYY-MM-DD |
decimal_separator |
(N)VARCHAR(1) |
Decimal separator of the user |
thousands_separator |
(N)VARCHAR(1) |
Thousands separator of the user |
template_user |
INTEGER |
Flag template user 1: Template user 0: Normal user |
hidden_user |
INTEGER |
Flag hide user (e.g. when assigning, requesting, etc.): 1: Hide user 0: Display user |
substitute_required |
INTEGER |
Flag substitute required 1: Substitute required 9: Substitute not required |
block_replacement |
(N)VARCHAR(50) |
Not used |
ldap_id |
INTEGER |
ID of the LDAP directory configuration used to import the user |
user_dn |
(N)VARCHAR(1000) |
LDAP identifier of the user |
timezone |
INTEGER |
Not used |
certificate_serial |
(N)VARCHAR(50) |
Not used |
certificate_issuer_cn |
(N)VARCHAR(255) |
Not used |
certificate_issuer_org |
(N)VARCHAR(255) |
Not used |
certificate_issuer_country |
(N)VARCHAR(3) |
Not used |
certificate_dn_cn |
(N)VARCHAR(255) |
Not used |
certificate_dn_org |
(N)VARCHAR(255) |
Not used |
certificate_dn_country |
(N)VARCHAR(3) |
Not used |
certificate_hash |
(N)VARCHAR(50) |
Not used |
nav_menu_layout |
INTEGER |
Menu layout 1: Category |
settings |
(N)VARCHAR(MAX) |
Storage of filter settings and sorting of the interface as XML structure. The structure is generated automatically if the column is empty. |
client_settings |
(N)VARCHAR(MAX) |
Storage of the window size and position of JobViewer in JSON format |
dashboard_settings |
(N)VARCHAR(MAX) |
Not used |
create_date |
DATETIME |
Create date |
created_by |
(N)VARCHAR(50) |
Created by |
modify_date |
DATETIME |
Modify date |
modified_by |
(N)VARCHAR(50) |
Modified by |
ldap_sync_date |
DATETIME |
Date of the last LDAP synchronization |
update_setting |
INTEGER |
Flag requiring the XML file to be recreated. For example after changing inboxes. 1: Refresh XML file 0: No action |
