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

Release : 4.9.1

Component :

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.

There's another downloadable graphical reference that provides more detail, which can be found at https://docs.microsoft.com/en-us/sql/relational-databases/security/permissions-database-engine?view=sql-server-ver15

The TDM documentation 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

(https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/installing/install-test-data-manager/install-the-repository.html)

 

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 Database Requirements at https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/installing/install-test-data-manager/system-requirements.html#concept.dita_a5bb631567e0ae7aead6971e0b45c6ab14a1bb93_databaserequirements

Database Level Roles - https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles?view=sql-server-ver15

A downloadable graphical reference can be found at https://docs.microsoft.com/en-us/sql/relational-databases/security/permissions-database-engine?view=sql-server-ver15