Before you start using Data Copy to copy data, you must obtain the following permissions:
- to allow access to the foreign server created during the QueryGrid setup
- to allow the foreign server to access the objects being copied.
When you create a Data Copy plan, you will provide a database user for Data Copy to use to login to the database. This user requires the following permissions:
- SELECT Permission on DBC.ServerInfoV or DBC.ServerInfoVX
- CONNECT THROUGH Permission to Service Account associated with Foreign Server
- INSERT and SELECT Permission to Foreign Server