Database login requirements

Last Updated : Dec 26, 2020 |

The POM database server requires an administrative login with Database Administrator (DBA) read-write privileges. The following table shows the values for this administrative login. If you use a different administrative login, ensure that the login has the same permissions as the login listed in the following table:

Property

MSSQL

Oracle

PostgreSQL

Database Administration Login

sa

For other user, see Database user requirement.

system

For other user, see Database user requirement.

postgres

Database Administration Password

password for sa

password for system

password for postgres

You do not need to provide complete DBA permission to POM database user. If you need to control the permissions or privileges, see Database user requirement for required role or privileges.

If database users have database owner access that are supported by POM, the following access is not required for different databases:

Access

Database

sa

Microsoft SQL Server

system

Oracle

postgres

Postgres

The database server acts as a central repository for all information that POM stores and retrieves. For scalability, fault tolerance, and security required for your organization, you can install and configure database servers in multiple ways. Therefore, specific configuration instructions are not part of this guide.

Important:

The installation and configuration of the database server are beyond the scope of this manual. Consult a qualified DBA to deploy your chosen database platform.