Database Users Configuration

Aras Innovator provides the option to create, populate existing, or configure existing databases in MS SQL Server. To allow continued upgrading of Aras Innovator certain guidelines should be followed regarding the MS SQL Server users and logins used to access the Aras Innovator database.

• The “innovator” user must have access to the database.

  This user is created as part of a standard installation when using the create option.

  This must be configured manually when an installation uses the populate or configure options.

• The ‘innovator’ user must have database owner privileges.

  This privilege is created as part of a standard installation when using the create option.

  This must be configured manually when an installation uses populate or configure options.

• The “innovator_regular” user must have access to the database.

  This user is created as part of a standard installation when using the create option.

  This must be configured manually when an installation uses the populate or configure options.

  Innovator_regulator database users should NOT have database owner privileges.

• The non-system database objects should be owned by the ‘innovator’ database user.

  Non-system objects are those not created by MS SQL in initial creation of the database in MS SQL

  All installed objects are created with this owner.

  All objects created by the Innovator Server are created with this owner.

• Logins used by the ‘innovator’ and ‘innovator_regular’ database users should not be the same as the MS SQL Server System Administrator (SA) login.

  The ‘innovator’ and ‘innovator_regular’ database user logins should not match the ‘SA’ login

  The ‘innovator’ and ‘innovator_regular’ database user logins should not match any other MS SQL Server Administrator login used in addition to the ‘SA’ login.