What are the minimum list of GTREP User Privileges

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Could you please provide the list of minimum privileges that the GTREP user needs on a SQL Server database for CA TDM to function? 

Environment

TDM 4.10 and greater

Resolution

 

This is something that the SQL Server DBA should be able to determine for their environment. The SQL Server documentation has a nice graphical aid that might be helpful to you, see below.

The TDM documentation, Install the Repository, states the gtrep user account needs to be able to create/alter the following items:

• A database
• Tables
• Views
• Functions
• Procedures
• Indexes
• Primary and foreign keys
• Constraints

Based on the SQL Server graphical reference, and the fact the gtrep account needs to be able to create a database if needed, then db_owner would be your best option and Broadcom's recommendation.

Otherwise, you could try starting with:

• db_dareader
• db_denydatareader
• db_dawriter
• db_denydatawriter
• db_ddladmin
• db_securityadmin
• db_accessadmin

Your SQL Server DBA should be able to verify the roles to grant that would allow minimal access, as required by our documentation.

Additional Information

Also see:

• TDM Database Requirements 
• Microsoft Database Level Roles
• Microsoft Permissions (Database Engine), which also contains a downloadable graphical reference.