Requirements for SQL Access on TDM Repository & Shredder Database
Article ID: 128441
CA Test Data Manager (Data Finder / Grid Tools)
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.
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!).