For the current installation, POM is configured to use the Oracle database with a system user. Upgrading POM using a new database user or changing a system user to a new user with restricted privileges is not supported. Therefore, the users who already installed POM with a system user cannot use a new user with restricted privileges.
MSSQL
For MSSQL, a user with the dbcreator role privilege is required.
Note:
For MSSQL, POM supports database authentication and Windows authentication.
The MSSQL server authenticates a user who uses the login credentials or the Windows authentication mode to log in to the MSSQL database.
Important:
Fresh installation is supported for the POM fresh installation with restricted privileges. All the operations are supported as a new user creates the object, and the user has all privileges. Upgradation from the current version to the next version is also supported. Therefore, the users who install POM with new restricted privileges can perform a fresh installation and upgrade.
Characters supported in username
When logging in to databases, you can use @,-,\, or . characters in the username.
Oracle database - required role for database monitoring
To have SELECT access for POM user on Oracle's dynamic performance views, Database Administrator (DBA) must grant following Oracle role to POM user.
GRANT SELECT ANY DICTIONARY TO <pom_user>;
SQL Server database – required role for database monitoring
To have SELECT access for POM user on dynamic management views and functions that provide information about database health statistics, DBA must grant following SQL Server role to POM user.
GRANT VIEW SERVER STATE TO <pom_user>;
Postgres database - required role for database monitoring
To allow POM Postgres user to read pg_stat_* views which provide information about database health statistics, DBA must grant following Postgres role to POM user.
GRANT pg_read_all_stats TO <pom_user>;
Note:
POM for Postgres database require pg_stat_statements module for tracking planning and execution statistics of all SQL statements executed by a server. This module is not available globally but can be enabled for a specific database with CREATE EXTENSION.
Contact your database administrator to install and enable the pg_stat_statements extension in POM PostgreSQL database server.
