Permissions
SQL Server permissions required for Central Repository
When using SQL Server Integration Services
Permissions required on the remote instance:
Database | Permissions | Description |
SQLWATCH |
| To read data from the remote instance |
Permissions required on the local instance where central repository is
Database | Permissions | Description |
SQLWATCH |
| To read data from the local instance |
| To write data from the remote instance | |
| For bulk inserts |
When using Linked Server
TBC
Last updated