Relational database

System privileges required

Create Table

Object privileges required

ABORT
DELETE
DROP
LIST
UPDATE
TRUNCATE
INSERT
ALTER

Oracle database

The database user for PQM needs to have the NEXEED_BASIC_ROLE role. Please consult the IAS operations manual for further information.

InfluxDB database

Creating retention policies

PQM tries to automatically create the necessary retention policies in InfluxDB, if they don’t exist. PQM uses the injected PQM Influx user. That user usually does not have the necessary permissions to create retention policies for security reasons.

In the case, the retention policies MUST be created manually.

The following retention policies are required:

Name	Duration	Replication Factor	Description
rp_process	14d (default)	2 (recommended)	Stores process curves and all meta data.

Name

Duration

Replication Factor

Description

rp_process

14d (default)

2 (recommended)

Stores process curves and all meta data.

Duration and replication factor can be adjusted according to specific requirements.

After the duration has passed, process curves are deleted and no longer available in the UI for analysis or export.

The replication factor should be set to at least 2 in a production environemnt to ensure data availability in case of a node failure in an Influx cluster deployment.

Non-admin user roles required

Cluster proxy configuration

When comparing multiple processes, Influx query URLs can get too long (up to 50k characters). The proxy servers in between PQM and Influx nodes have to be configured to support URLs longer/up to 50k characters.