The final step in setting up the database is to create a user (db_owner) that EBA DMS system will use to log on and write into the database.
The instructions are written for the PostgreSQL database. For other database types consult your IT adminstrator or corresponding documentation.
The pgAdmin tool is used to create the user, which is automatically installed when the PostgreSQL database is installed. You can run PgAdmin from the [Start] menu on the server where you installed the PostgreSQL database, or on your computer if you have installed pgAdmin and configured the database server to access it.
- Open pgAdmin and select desired server. Right-click on Login Roles, and then New Login Role…
2. In the first tab under Role name select your username:
3. In Definition tab define password:
4. Allow creating new databases in tab Role privilieges: