Requirements for SQL Access on TDM Repository & Shredder Database

Products

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

Issue/Introduction

Could you provide documentation on SQL Account Access, Privileges for Repository, Shredder and TDM Databases?

We need to  provide documentation to our Security team for getting access. We have checked on documentation but could not find any much information.

Environment

Release:
Component: TDMSHR

Resolution

Engineering and Product Development team said that the user needs to be setup as the "db_owner" since the shredder needs to create schema (db, tables, columns) as well as read/write data.

NOTE: access to the shredder database is independent from the repository (you don't need gtrep user!).