Could you please provide the list of minimum privileges that the GTREP user needs on a SQL Server database for CA TDM to function?
TDM 4.10 and greater
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:
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:
Your SQL Server DBA should be able to verify the roles to grant that would allow minimal access, as required by our documentation.
Also see: