Permissions required for installing TopTeam Database Objects into an existing SQL Server Database

What is this article about?

This article describes which permissions are required to install TopTeam Database Objects and how to grant those permissions to SQL Server Logins.

Who should read this?

  • TopTeam Administrators
  • Database Administrators

Prerequisites

  • You must have Administrative permissions to grant “db_ownerDatabase Roles to SQL Server Logins.

Step 1. Run SQL Server Management Studio from Windows App menu

wpid32368-SSMS.png

Step 2. Log into SQL Server

wpid32366-Login.png

Step 3. Select the Login who will install TopTeam Database Objects into an existing SQL Server Database

wpid32367-LoginProperties.png

Step 4. Grant Database Roles on TopTeam Database

wpid32369-UserMapping.png

When TopTeam Database Objects are installed, the above permissions are not required for day-to-day working.
For more details, refer to the article SQL Server Roles and Permissions required for day-to-day working with TopTeam.

Revised: November 24th, 2016