Requirements for SQL Access on TDM Repository & Shredder Database
book
Article ID: 128441
calendar_today
Updated On:
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!).