Diese Seite ist nur auf Englisch verfügbar.

Shopfloor Management Essentials database

This is the database required by Shift Book(smsb), Andon Live(smal), KPI Reporting(smkpi), Administration(smadmin) and ConfigBridge(smcb). We require this database to be set up inside a separate database schema. This means that the database can only contain the SM Essentials database objects and no objects from any other module.

Furthermore, one database schema per tenant is required. Multiple tenants can never access the same SM Essentials database.

Create database

The following script creates an empty SM Essentials database. This script is not necessary within Bosch as database provisioning will be done by the Central IT Department Bosch Digital.

Note: The Shopfloor Management database scripts require a default tablespace.

Please replace the following placeholders before executing this script.

  • $$SchemaUsername$$

  • $$SchemaPassword$$

  • $$DATAFILEPATH_1$$

-- create tablespaces
CREATE BIGFILE TABLESPACE $$SchemaUsername$$DATA_PDAMDA DATAFILE '$$DATAFILEPATH_1$$' SIZE 1G AUTOEXTEND ON NEXT 500M MAXSIZE 50G;

-- create users
create user $$SchemaUsername$$ identified by $$SchemaPassword$$
  default tablespace $$SchemaUsername$$DATA_PDAMDA
  temporary tablespace TEMP
  quota unlimited on $$SchemaUsername$$DATA_PDAMDA;

Supported Versions

Oracle 19c Enterprise

DBs / Schemas / Users

Shopfloor Management Essentials Schema

Required Privileges

NEXEED_BASIC_ROLE, NEXEED_EXTENDED_ROLE, NEXEED_MONITORING_ROLE

Relative Capacity

5 GB / 1 line / year, depends heavily on customer specific use-case

Database permissions

The database needs the following roles:

  • NEXEED_BASIC_ROLE

  • NEXEED_EXTENDED_ROLE

  • NEXEED_MONITORING_ROLE

    The roles are defined in the Nexeed IAS Operations Manual, Chapter 6.10. Database User Setup and Configuration.
Edit this pageDiese Seite bearbeiten

Feedback on this pageFeedback zu dieser Seite