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.