Table of Contents

Database User

A user with the following rights must be created on the database server :

Creating (CREATE, REFERENCES) a Schichtplaner schedule database
Querying and editing (SELECT, INSERT, UPDATE) the schedule database
Creating (CREATE TEMPORARY TABLES) temporary tables

You can create a user using the following commands:


                            CREATE USER 'spuser'@'3.127.186.43' IDENTIFIED BY 'secret123!' REQUIRE SSL;


                            GRANT SELECT, INSERT, UPDATE, CREATE, REFERENCES ON `sp_schedule_%`.* TO 'spuser'@'3.127.186.43';

                            GRANT CREATE TEMPORARY TABLES ON *.* TO 'spuser'@'3.127.186.43';

Notes:

You can choose your own username (here: spuser) and password (here: secret123!).

This information will be stored in the schedule settings.
The self-hosted database is accessed from the application server with the IP address 3.127.186.43.
The name of a schedule database is determined by the application server and always begins with sp_schedule_.
You can test whether a valid connection with the created user is possible in the self-hosting settings of the schedule database.

Database User

Further Information