Skip to main content
System StatusContact Support
VersionOne Community

What database rights are required if my DBA creates our database?

Answer

When installing VersionOne with an existing database, the Windows/SQL account used for setup needs fewer SQLServer rights, as it does not need to create a new database. To allow setup to create VersionOne database schema, modify database configuration settings (see below), and populate it with application data, the account used (either the individual running setup or a SQL login specified during setup) must be a user on the VersionOne database, and a member of the db_owner database role.

Note that any upgrades to VersionOne also require that the account used during setup be db_owner on the VersionOne database.

VersionOne Database Configuration

The VersionOne application requires its database be configured as follows:

ALTER DATABASE [{database}] SET
ARITHABORT ON,
CONCAT_NULL_YIELDS_NULL ON,
QUOTED_IDENTIFIER ON,
ANSI_NULLS ON,
ANSI_PADDING ON,
ANSI_WARNINGS ON,
NUMERIC_ROUNDABORT OFF

If not already set to these values, they will be updated when setup executes