Managing Database Connections and Permissions

Documentation
Article Library

Date: 9/29/2014
Applies to Version: v4.5, v4.6, v4.7 and v4.8

This article provides information on the database permissions required for creating and connecting to DocuNECT databases. DocuNECT has a built in process for creating and upgrading databases. In v4.5 and v4.6 this is built into the web installation process. In v4.7 and v4.8 this process has been separated to a standalone application called Database Manager.

Creating a DocuNECT Database

The user that creates the initial database needs to have the dbcreator role as shown below. We recommend that the user be called cmsdbowner.

DBRoles.JPG

Once the database is created this user will be assigned as the database owner.

Upgrading a DocuNECT Database

When upgrading a database, use the database owner account created as part of the database creation step as objects within the database are created and updated.

Connecting to a DocuNECT Database

The main application that requires a connection to the database is the DocuNECT Web application. This user is assigned during the web installation process and does not have to be the database owner. We recommend creating a separate database user called cmsdbconnect.

1. Create the user cmsdbconnect.
2. In the Properties of the user object, in the User Mapping section, make sure the user has the following permissions to the database:

  • Public
  • db_datawriter
  • db_datareader

3. In the database schemas, grant permissions to Select and Execute in the dbo schema.