Database Installation

This page provides setup instructions for each supported database management system. For each one, it explains how to:

• Install the database management system.
• Create a dedicated database (or schema, depending on the database system) and required database account for USP Manager.
• Grant the required permissions.
• (Optional) Verify connectivity to the database using the open-source usql command-line interface.
• (Optional) Run a query to confirm access.

Oracle

1. Install Oracle Database

Refer to the Oracle official documentation for installation instructions.

info

Ensure that Oracle Database is installed, running, and reachable from the host where USP Manager is deployed.

2. Create a dedicated user and grant permissions

Run the following commands as an Oracle DBA to create a dedicated user for USP Manager and grant the required permissions:

CREATE USER uspmanageradm IDENTIFIED BY "usp-manager-oracle-password";
GRANT CONNECT, RESOURCE TO uspmanageradm;

3. (Optional) Verify connectivity

Use the usql client to confirm that the uspmanageradm user can connect to the database:

usql godror://uspmanageradm:usp-manager-oracle-password@//host:1521/service

Expected output:

Connected with driver godror
Type "help" for help.

godror:uspmanageradm@host/service=>

4. (Optional) Run a test query

Run a simple query to confirm that the schema is accessible and currently empty:

SELECT table_name FROM user_tables;

Expected output on a new schema:

(0 rows)

This confirms that:

• Oracle Database is installed and running.
• Required client libraries are available.
• The uspmanageradm user exists and can connect.
• The schema is reachable and currently empty.

Microsoft SQL Server

1. Install Microsoft SQL Server

Refer to the Microsoft SQL Server documentation for installation instructions.

info

Ensure that Microsoft SQL Server is installed, running, and reachable from the host where USP Manager is deployed.

2. Create a dedicated database and login

Run the following commands using SQL Server Management Studio (SSMS) or sqlcmd:

CREATE DATABASE uspmanager;
CREATE LOGIN uspmanageradm WITH PASSWORD = 'usp-manager-mssql-password';

3. Create the user and assign permissions

USE uspmanager;
CREATE USER uspmanageradm FOR LOGIN uspmanageradm;
ALTER ROLE db_owner ADD MEMBER uspmanageradm;

4. (Optional) Verify connectivity

Use the usql client to confirm that the uspmanageradm login can connect to the database:

usql sqlserver://uspmanageradm:usp-manager-mssql-password@host:1433/uspmanager

Expected output:

Connected with driver sqlserver
Type "help" for help.

mssql:uspmanageradm@host/uspmanager=>

5. (Optional) Run a test query

Run a simple query to confirm that the database is accessible and currently empty:

SELECT name FROM sys.tables;

Expected output on a new database:

(0 rows)

This confirms that:

• Microsoft SQL Server is installed and running.
• Required client libraries are available.
• The uspmanageradm login and user are correctly configured and can access the database.
• The database is reachable and currently empty.