empower® Database

Hosting Option: Corporate Cloud

Required Permissions: IT Admin

The empower® Database is an SQL server database. To use this database, you need to create database users that are granted specific permissions.

If you are hosting in the empower® Cloud, the empower® Database is maintained by empower.

The empower® Database is the single source of truth (SSOT) for the empower® Services. That means that all data that is required to run empower® is stored in one location.

There are no additional data sources that the services might use.

Note

For empower® Charts, empower® Chart Creation and empower® Branding, hosting a database is not required.

All contents will be provided and are stored locally.

Database Users

To run empower®, you need two types of database users:

  • the Database Access User (ServiceUser)

  • The Database Update User (UpdateUser)

Database Access User

The Database Access User provides access to the database for the empower® Backend. The Database Access User requires permissions to add and edit data in the database.

Therefore, it requires the database roles empowerRole and hangfireRole:

  • empowerRole – specific database role for empower® that can access all database schemes and add or edit data within them. It is required to run the empower® Backend.

  • hangfireRole – specific database role for empower® that can access one specific database scheme that can be used to save data for background processes.

Important

The Database Access User (ServiceUser) must not have the role sysadmin on the SQL Server.

Database Update User

The Database Update User has the database role db_owner. The Database Update User is responsible for the database update.

Users that have been granted the role db_owner can execute all configuration and maintenance work on the database.

In addition, they can delete the database in SQL Server Management Studio.

The Database Update User must not be the same user as the Database Access User (ServiceUser). Therefore, the database role db_owner must not be granted to the Database Access User (ServiceUser).

Note

The Database Update User is required if the empower® Version is updated.

Was this article helpful?

/

Comments

0 comments

Article is closed for comments.