DB Connection Information for Read Access

Property

Description

DB-Connection parameter

Database Connection information is needed for WebOffice 10.7 SP1 in order to read user role and access rights information from the User Management database.

Note: See chapter Database Connections for details on database connections as well.

Note: If you like to use a SQLite file as a UserManagement database the following database connection parameters have to be used:

jdbc:sqlite: C:/work/mydatabase.db (Windows)

jdbc:sqlite: /home/leo/work/mydatabase.db (Linux, Mac OS X)

DB user name

Database user name to provide (read) access to the database.

Note: If the connection points to a MS Access DB, that is not secured via user/pwd, please configure the default user Admin.

Password

Password of the database user.

Oracle database schema

Name of the Oracle schema when different than the one of the user that is used for login.

Note: This functionality is required if the Oracle schema is created with a different user (e.g. UMDB_ADMIN) than the one used for connection with WebOffice (e.g. UMDB_USER).

Note: Example Scenario:
UMDB_ADMIN has created the Oracle schema
UMDB_USER shall be configured in the application configuration for DB read access

The user UMDB_USER has to be able to do the following command:

ALTER SESSION SET CURRENT SCHEMA = UMDB_ADMIN

Note: The respective schema owner has to be configured in  the web.config as well. See chapter ORACLE Connection Parameter for details.