Activate WebOffice usermanagement

The WebOffice10.9R3-DVD includes a sample user management database (UMDB) with several configured restrictions for the WebOffice 10.9 R3 Sample Project. If you want to activate the sample UMDB, please be aware that you have to fulfill the following prerequisites:

a valid WebOffice usermanagement license

an installed and configured UserManagement Admin Web application (see chapter WebOffice User Management (Application Server) and subsequent chapters)

a configured UMDB connection in web.config (see chapter Configure the File web.config and subsequent chapters)

a prepared empty UMDB (see chapter Create a User Management Database)

a configured UMDB connection in the basic settings (see chapter Configure Basic Settings for WebOffice User Management)

a configured UMDB connection in the application configuration (see chapter User Management)



You can only activate WebOffice usermanagement if you already have a working WebOffice Sample Project. If this is not the case, start with chapter Publish Map Documents instead.

Copy WebOffice Sample Project UMDB Data

You will need the following files from the WebOffice10.9R3-DVD:



The sample UMDB SQLITE file can be found in the WebOffice10.9R3-DVD under WebOffice10.9R3-DVD\SampleProject\Data\UMDB\UMDB_SampleProject.sqlite. Copy the SQLITE file to your preferred data directory (e.g. D:\Data\SampleProject\).

Adjust the UMDB_SampleProject.sqlite

Now open the UMDB_SampleProject.sqlite in a text editor and use the search/replace function to adjust the URLs/paths to meet your server name(s).



Use at least a text editor like e.g. UltraEdit32, PSPad or Notepad++ for configuring the SQLITE file.

If you encounter problems when editing the user management database using a text editor, try to make the adjustments using the DBeaver tool. For more information, see the chapter Adjusting service URLs in a user management database with DBeaver.


Search for the term rest|siteadmin@ and replace it with the name of your server used in the URLs of your services and the ArcGIS Server user who has access to the services if no siteadmin exists in your environment..



You can find more information about this in the Adjust Project Configuration chapter.


The following map service URLs have to be adjusted:










After all changes have been done, save the file.

Import the UMDB SQLITE File with User Management Database Staging

Open WebOffice author standalone with the correct application profile that links to the prepared empty UMDB and go to Staging > User Management Database.



Make sure that your application profile links to an empty user management database. Any previously existing database content of your current profile will be overwritten!


Start usermanagement staging in the  WebOffice author standalone

Start usermanagement staging in the  WebOffice author standalone


A file dialog opens where you can select the sample UMDB SQLITE file. Continue if you are sure to have selected the correct profile.


Import of the data into the database

Import of the data into the database


Save your Sample Project to transfer the data in the UMDB.

Another possibility to transfer the data into the user management database is by right-clicking on the User management status display in the status display.


Synchronize User management

Synchronize User management

Reload User Management and Start WebOffice Sample Project

Open SynAdmin and reload User Management in the Application Tab. Now you can start the WebOffice 10.9 R3 Sample Project and log in with the following users:

Administrators (can do everything)

oUser: admin, Password: admin

Editors (can edit)

oUser: editor1, Password: editor1

oUser: editor2, Password: editor2

Users (can only view)

oUser: m.mustermann, Password: m.mustermann


Configured Restrictions in the sample UMDB:

Different application profiles (export, editing, viewing) for the groups listed above

editor1 and editor2 have a different initial map extent & initial map view

m.mustermann has several restrictions

ono access to map Editing services

ono access to any cadaster layers

orestricted access to sewer layers (only viewing)

ono access to map views containing the disabled map services

ono access to basemaps Cadaster and Land Development Plan

ono access to print templates besides A4

editor1 and editor2 are allowed to use group based editing only (no access to features created by another group (e.g. Administrators))

oChange to user based editing (no access to features created by another user) by assigning the respective filter


Interface of Viewing user - Restricted access to editing functionality

Interface of Viewing user - Restricted access to editing functionality


Interface of Admin user - Full access to editing functionality

Interface of Admin user - Full access to editing functionality



See chapter WebOffice User Management for general information about the WebOffice usermanagement.

See chapter UserManagement Admin Web for details about the UserManagement Admin Web application.

See chapter User Management for details about the user management connection in the application configuration.